Forum Discussion

Amar-Agnihotri's avatar
Amar-Agnihotri
Icon for Resolver I rankResolver I
4 years ago

We found extra characters at the end of JSON input

 I have created a function in power query to get the authorization code which i will use to generate the access token to call the REST api. Here is the function definition -    () => let body = "...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi Amar-Agnihotri 

 

It seems the response result of the Web.Contents("https://login.microsoftonline.com...................) section is not a standard JSON type data, so this error appears when using Json.Document() to return the content. You can remove the "()=>" characters to convert it back into a common query and check its result. 

 

Best Regards,
Community Support Team _ Jing

  • Amar-Agnihotri's avatar
    Amar-Agnihotri
    Icon for Resolver I rankResolver I
    4 years ago

    v-jingzhang Hello,

     

    Does this makes sense . I changed the code . It looks like this now -

     

     

    How will it generate the auth code?