Rest Message error

[cuchi]

Hi There,

i hope this email finds you all well.

I was asked to retrieve data out of snow to PowerBI.

what i did was

- created a couple of REST Messages (one for each table)

- created a user for integrations purposes with proper permissions (ACLs, roles, etc)

- Installed powerBI in my laptop.

- connected to specified endpoint using basic auth

As a result of the above steps i could retrieved data from user, interaction, groups and interaction tables. However, i could not from incident and catalogue tasks (error attached) 

why the error?

Also, another colleague of mine is trying to connect the same way but he cannot while i can. would you know why?

regards,

Max

[Kalyani21 · Accepted solution]

Hello Cuchi,

From Power BI community, what I found is:

We found a workaround for this parsing problem. We used the sysparm_fields to get just the columns that were needed. This way we could retrieve all the lines of the table.

let
Source = Json.Document(Web.Contents("https: //YYYYYYYYYYY .service-now. com/api/now/ table/tablename?sysparm_fields=  column1,column2,column3,column4,column5"))
in
Source

No problem was found getting all the columns in separated groups. 

Unfortunately, it's still unknown why it returns a parsing problem when I try to retrieve all the columns without specifying them. 

Refer below thread: 

https://community.powerbi.com/t5/Desktop/API-REST-GET-DataFormat-Error-We-found-an-unexpected-charac...

Hope this helps.

Thanks & Regards,

Kalyani Shaha

[cuchi]

Hi Kalyani ,

thank you very much for your time and help.

i was doing exactly what you suggested, but the "endpoint" field is not long enough to fit all columns i want to retrieve from snow. Any other place to specify them?

Also, would you know why my colleague could not connect at all even when we use the same account?

any place to track the error message?

regards,

Max