Connection to Intrado API?

[diego_forero30]

Hello there!

I'm trying to stablish an API connection to Intrado's platform, with no luck until the moment.

I've tried Json.Document(Web.Contents"URL"... etc; also tried with Web source in power query, with no results.

I have all the credentials Intrado mentions in the documentation available online, and I know those are the right credentials, which makes me think probably I'm doing something wrong in my code.

Here the example in the documentation:

The format of the call is: 

https://api.onlinexperiences.com/scripts/Server.nxp?LASCmd=AI:4;F:APIUTILS!50566
&APIUserAuthCode={YourAuthCode}
&APIUserCredentials={YourCredentials}
&ShowKey={ShowKey}
&FromDateTime={FromDate in YYYY-MM-DD HH:MM:SS format}
&ToDateTime={ToDate in YYYY-MM-DD HH:MM:SS format}
&ActivityTypeFilter={filter code list, in |OPTION|OPTION| format…}
&FilterUserType={0|1|-1 where 0 = attendees, 1 = exhibitors, -1 = both}

Any help will be highly appreciated.

[diego_forero30]

Hi Ibendlin,

Not really, I haven't took a look at that, because in desktop once I go to Get data -> Web I get the following:

"SQL failed. See your contact for more information."

Probably you have something in mind I could check?

[lbendlin]

That's a weird error message - are you sure this is coming from the Web.Contents step ?

[diego_forero30]

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.

[diego_forero30]

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.

[diego_forero30 · Accepted solution]

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=You..."))

in

Source

Where of course you have to use your own auth code, credentials and showkey.

[lbendlin]

What have you tried so far?  Are you aware of the Query section in Web.Contents ?