AaronNZ
Novice

Webrequest http post data from SP list

Jump to solution

I have a problem which I can't seem to figure out.

I have a SPO list for user details (first name,last name,title,office,department,manager) and what i want to do is submit this via a webservice to another API.

 

My workflow has the following components.

1. Query list (queries the list which has the user details in it)

2. Call HTTP Web Service

3. Send an email

 

The issue I an encountering is the query list returns data in a "collection" which is JSON looking but the web request only wants to accept a Dictionary variable and i can't figure out how to convert these data types. I know that the collection variable can contain an array of list items but the dictionary doesn't handle arrays and i'm guessing the web request can't pass arrays so hence the dictionary variable.

 

Is anyone able to steer me in the right direction?

 

Thanks,

Aaron

Labels: (1)
0 Kudos
Reply
1 Reply
AaronNZ
Novice

Re: Webrequest http post data from SP list

Jump to solution

Made it work by using "Get item from collection" and putting the data into the dictionary variable which is submitted to the remote API

0 Kudos
Reply