Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Connect to RESTapi with x-wsse in header

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

1 ACCEPTED SOLUTION
Nolock
Resident Rockstar
Resident Rockstar

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

 

View solution in original post

1 REPLY 1
Nolock
Resident Rockstar
Resident Rockstar

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors