https://community.fabric.microsoft.com/t5/Developer/Jira-API-pull-quot-DataFormat-Error-We-found-extra-characters-at/m-p/1988880#M30829 <P>This could be the API did not return a properly formatted JSON.You can try using Fiddler or F12 of the browser to view the content actually sent by the API.</P> Fri, 30 Jul 2021 06:38:43 GMT V-lianl-msft 2021-07-30T06:38:43Z https://community.fabric.microsoft.com/t5/Developer/Jira-API-pull-quot-DataFormat-Error-We-found-extra-characters-at/m-p/1985282#M30784 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I've tried tons of examples off the internet, but still keep getting this DataFormat.Error. Any advice to finding the issue?</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">&nbsp;</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Does it have anything to do with paging data coming back? Is it the call going out? Wish the error messages were a bit more descriptive here.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">let Auth_Key = "Basic " &amp; Binary.ToText(Text.ToBinary("xxx:xxx"), 0), Source = Json.Document(Web.Contents("https://jira.xxx.com/rest/api/1/issue/MIA-8263", [Headers=[#"Content-Type"="application/json", Authorization="Auth_Key"]])) in Source</LI-CODE><P>&nbsp;</P> Wed, 28 Jul 2021 16:43:02 GMT https://community.fabric.microsoft.com/t5/Developer/Jira-API-pull-quot-DataFormat-Error-We-found-extra-characters-at/m-p/1985282#M30784 dude95 2021-07-28T16:43:02Z https://community.fabric.microsoft.com/t5/Developer/Jira-API-pull-quot-DataFormat-Error-We-found-extra-characters-at/m-p/1988880#M30829 <P>This could be the API did not return a properly formatted JSON.You can try using Fiddler or F12 of the browser to view the content actually sent by the API.</P> Fri, 30 Jul 2021 06:38:43 GMT https://community.fabric.microsoft.com/t5/Developer/Jira-API-pull-quot-DataFormat-Error-We-found-extra-characters-at/m-p/1988880#M30829 V-lianl-msft 2021-07-30T06:38:43Z