Connect to RESTapi with x-wsse in header

[Anonymous]

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

[Nolock · Accepted solution]

Hi @Anonymous,

I have never worked with WSSE, but I will try my best to help you.

Resources I've read:

• https://help.emarsys.com/hc/en-us/articles/115004745889-Introduction-to-the-Emarsys-API - API Description - doesn't help
• https://oroinc.com/orocrm/doc/2.0/dev-guide/cookbook/how-to-use-wsse-authentication - a explanation of the header
• https://docs.microsoft.com/en-us/powerquery-m/web-contents - PQ Web.Contents which can send a GET/POST/... request with a header
• https://raw.githubusercontent.com/emartech/developer-hub-public-assets/master/resources/EmarsysV2PostmanCollection.json API description for POSTMan

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="""""
        ]
    ]
)