March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Solved! Go to 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.
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?
That'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.
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=You..."))
in
Source
Where of course you have to use your own auth code, credentials and showkey.
What have you tried so far? Are you aware of the Query section in Web.Contents ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
20 | |
12 | |
10 | |
9 | |
7 |
User | Count |
---|---|
40 | |
26 | |
16 | |
16 | |
11 |