current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 2 down vote favorite
2

I am getting response in following JSON format 

Affected_x0020_Program: {
results: [2]
0:  {
  __metadata: {
  id: "c6eb23d2-b6de-4f4b-a72c-052983faf36a"
  type: "SP.Data.ProgramsListItem"
}-
  Title: "Vijay"
}-
1:  {
  __metadata: {
  id: "0e2b317e-bfc9-4403-bff5-82721415982d"
  type: "SP.Data.ProgramsListItem"
}-
  Title: "Hole"
}-
-
}

How to read value of Affected_x0020_Program in SharePoint designer workflow ?

Thanks in advance.

share|improve this question

1 Answer 1

up vote 2 down vote

First of all you need to add a "Call HTTP Web Service" action, which you might already did. Then in the "ResponseContent to" you have to assign it to a variable so that you can read from your json later.

Then you have to add a "Get an Item From a Dictionary" action where you will read from your responseContent variable.

It will show something like "Get item by name or path from dictionary (Output to item)

You will replace the item by name or path with the path of what you want from that json. In your case it would be enough if you type ProgramId.

Sorry if I explained things that you already know but you did not provide a bit more of detail. I hope this helps you. If not, please share more details

share|improve this answer
    
Thanks . I have already called HTTP web service and i am able to read values but problem is that when i am trying to read using 'ProgramId 'getting blank value .I think reason of blank value is 'ProgramId' contains 3 element so problem is here to read these 3 elements ? So how to read these element values in Sharepoint designer workflow? –  user3760501 Apr 13 at 6:21
    
Problem is how to read Multi select lookup value in SharePoint designer workflow using Get item ? –  user3760501 Apr 13 at 7:03
    
How to read follwoing JSON format Affected_x0020_Program: { results: [2] 0: { __metadata: { id: "2fbd598f-c7b5-4f01-baf8-7853aada5f0f" type: "SP.Data.ProgramsListItem" }- Title: "Vijay" }- 1: { __metadata: { id: "7d6d2d33-27c8-4d50-846a-bca923dfdb04" type: "SP.Data.ProgramsListItem" }- Title: "Hole" }- - } –  user3760501 Apr 13 at 12:52
    
@user3760501 - Just quick question. Are you making sure that the Variable where you are placing the ResponseContent is of type DynamicValue? –  RicardoAleG Apr 13 at 15:52
    
@user3760501 - Try this: 1. Add another "Get an item from a Dictionary". In the "get" part of it add "ProgramId/element", in the "from" part use the variable holding the ResponseContent, and in the output create a new variable of type "Dictionary" 2. Add a "Count Items in dictionary" action. In the dictionary part of it add the newly created variable of type dictionary and in the output part of if create a new variable named count or whatever. –  RicardoAleG Apr 13 at 16:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.