Getting data using rest api in sharepoint hosted app with vs

Bouthaina Tlijani

8y1.6k.NET

Hello,

I'm trying to get data from a list using rest api in sharepoint hosted app.. my resturl is "appurl+ "_api/web/lists/getByTitle('ListCollab1602')/items?$select=MailManager"

in the HttpSend i use : accept : "application/json; odata=nometadata" in the RequestHeader, so the result is : {"value":[{"MailManager":"[email protected]"},{"MailManager":"[email protected]"}]}

so how can i retrieve only the mail without the {"value":[{"MailManager":" ????

Ps: i tried to put "value" in the GetDynamicValueProperty but i get this exception :

An unhandled exception occurred during the execution of the workflow instance. Exception details: System.InvalidOperationException: Looking up a value using a key is not supported on an instance of 'Microsoft.Activities.Dynamic.DynamicPrimitive'. at Microsoft.Activities.Dynamic.DynamicItem.TryGetValue(String key, DynamicItem& value) at Microsoft.Activities.Dynamic.DynamicValueBuilder.PathSegmentFactory.ObjectPathSegment.Get(DynamicItem obj)

Any help please :)

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bouthaina Tlijani8y ago
it gives me an exception which is :

An unhandled exception occurred during the execution of the workflow instance. Exception details: System.InvalidOperationException: Looking up a value using a key is not supported on an instance of 'Microsoft.Activities.Dynamic.DynamicPrimitive'. at Microsoft.Activities.Dynamic.DynamicItem.TryGetValue(String key, DynamicItem& value) at Microsoft.Activities.Dynamic.DynamicValueBuilder.PathSegmentFactory.ObjectPathSegment.Get(DynamicItem obj).
Guest User8y ago
Ok. I'm not sure what is in there to work with as my Sharepoint knowledge is next to nothing.

What exactly didn't work?
Bouthaina Tlijani8y ago
when i tried to use "dynamic jsonObject = JsonConvert.DeserializeObject(yourReturnedJsonString); " it didn't work for me so i'm trying to figure out how can i retrieve the data with the items that exists in the toolbox of the visual studio because i'm working with the sharepoint online "hosted app"
Guest User8y ago
What exactly do you mean with "without having to code"? I'm not exactly sure what you are trying to achieve.
Bouthaina Tlijani8y ago
pritaeas is there any way to retrieve only the data without having to code?? i mean with only the items that exists in the toolbox like ParseDynamicValue or something like that?? cause i already tried to fix this issue with coding but unfortunately it doesn't work :( and thnx in advance :D
Bouthaina Tlijani8y ago
Thank you soo much man :) you rock!
Guest User8y ago
You can use NewtonSoft Json (installed or install through nuget) to convert the json string to a dynamic object using:

dynamic jsonObject = JsonConvert.DeserializeObject(yourReturnedJsonString);