Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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=""""" ] ] )