Solved

Webrequest http post data from SP list

  • 28 September 2021
  • 1 reply
  • 34 views

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

icon

Best answer by AaronNZ 28 September 2021, 09:41

View original

1 reply

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

Reply