Forum Discussion
Connection to Intrado API?
So, the issue I was having was produced due to the syntaxis I was using for the call, that was not written in the way as the api accepts it.
The correct way would be something like:
let
Source = Xml.Tables(Web.Contents("https://api.onlinexperiences.com/scripts/Server.nxp?LASCmd=AI:4;F:APIUTILS!50566&APIUserAuthCode=YourAuthCode&APIUserCredentials=YourCredentials&ShowKey=ShowkeyYouWantToCall"))
in
Source
Where of course you have to use your own auth code, credentials and showkey.
Super UserThat's a weird error message - are you sure this is coming from the Web.Contents step ?
Yes,
Take a look:
In Changed Type step appears exactly the same.
- lbendlin
Ah, so what's likely happening is that your query parameters are doing a little number on their backend (similar to an SQL Injection attack). Remove the URL filters one by one to see when it stops breaking.
I already followed your advise, tried filter by filter, meaning removing APIUserAuthCode={YourAuthCode} &APIUserCredentials={YourCredentials} one per one, and still the result is exactly the same.
So, the issue I was having was produced due to the syntaxis I was using for the call, that was not written in the way as the api accepts it.
The correct way would be something like:
let
Source = Xml.Tables(Web.Contents("https://api.onlinexperiences.com/scripts/Server.nxp?LASCmd=AI:4;F:APIUTILS!50566&APIUserAuthCode=YourAuthCode&APIUserCredentials=YourCredentials&ShowKey=ShowkeyYouWantToCall"))
in
Source
Where of course you have to use your own auth code, credentials and showkey.