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