Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I am trying to access an API (emarsys) which uses X-WSSE Authentification. I have a username and a secret.
Basically what I am trying to accomplish is to create a custom function that would parse the information from a column {customer_id} and return the json from the API. However, I am having troubles writing the script in the advanced editor to do so.
The API I am trying to reach is https://api.emarsys.net/api/v2/filter/{customer_id}/criteria
Does anyone know a script that would send the authentification information in the http header and let me receive the information?
Thanks in advance
Solved! Go to Solution.
Hi @Anonymous,
I have never worked with WSSE, but I will try my best to help you.
Resources I've read:
After reading it all I still don't know how to get a token. But if you had one, it'll be simple. You can use the function Web.Contents like:
Web.Contents( "https://api.emarsys.net/api/v2/filter/" & customer_id & "/criteria", [ Headers = [ #"X-WSSE" = "UsernameToken Username="""", PasswordDigest="""", Nonce="""", Created=""""" ] ] )
Hi @Anonymous,
I have never worked with WSSE, but I will try my best to help you.
Resources I've read:
After reading it all I still don't know how to get a token. But if you had one, it'll be simple. You can use the function Web.Contents like:
Web.Contents( "https://api.emarsys.net/api/v2/filter/" & customer_id & "/criteria", [ Headers = [ #"X-WSSE" = "UsernameToken Username="""", PasswordDigest="""", Nonce="""", Created=""""" ] ] )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |