Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

API REST - GET - DataFormat.Error: We found an unexpected character in the JSON input.

Hello!   I'm having some trouble connecting to SERVICENOW API REST.  When I make a call with 1500 lines (sysparm_limit=1500) I can get the data thougth this call correctly, but if I raise the numb...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi!

     

    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. 

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

What is the "65001" in the Json.Document function?  Do you get a json doc with just the Web.Contents part?  See what you get and then open it with the right function.  You may need to specify json format in the web call.

Regards,

Pat

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hello mahoneypat !
    Thanks for you time and help!

    The "65001" is related to UTF-8 encoding. But it's not necessary due to the GET method from Servicenow brings back automatically the UTF-8 encoding. 

    When I tried to get the data only through Web.Content it returns a JSON document which I can't parse after it. 

    Parse by text, returns a limited amount of data and Parse by JSON returns the problem with DataFormat.Error thing. 

     

    Regards,

    Kendi