path d/ does not return value from json dictionary using Sharepoint Designer 2013 web service

Question

I am using call

https://services.odata.org/V3/Northwind/Northwind.svc/Customers('ALFKI')?$format=json

I am logging the response and I see values

log the responseVariable {"odata.metadata":"https://services.odata.org/V3/Northwind/Northwind.svc/$metadata#Customers/@Angie Jude &$select=ContactName,CompanyName","CompanyName":"Alfreds Futterkiste","ContactName":"Maria Anders"}

next line in workflow i try to set value from dictionary using d/ContactName from the responseVariable (dictionary) and set to string but there is no value

tried using d/results[0]/ContactName as well nothing returned

Answer 1

except that in Sharepoint designer using the path did not work, using the Name only did work

Answer 2

Hi,
it works very well:

1. address: https://services.odata.org/V3/Northwind/Northwind.svc/Customers('ALFKI')
2. RequestHeader: dictionary with accept:application/json;odata=verbose and
   content-type:application/json;odata=verbose
3. method HTTP GET
4. in ResponseContent get d/ContactName

Result: Maria Anders

Answer 3

I did use that action however the path d/name did not work. Instead if I drop the d/ and use only the name then the value is found.

Answer 4

Try to use "Get an Item from a Dictionary" action.
Reference:Understanding Dictionary actions in SharePoint Designer 2013

---

Updated:
When you want to take a value from the return value, you need to pay attention to the structure of the return value, and take out the corresponding value according to the structure of the return value.

There is no d level in the structure of the API return value.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.