I am passing the below from Javascript as a parameter string via a GP Service. Once I grab this in the python script I am trying to parse it.... I am trying to write variables for address, distance, and id for each record in a for loop....but having issues..thoughts? for item in textstring [ 'employees' ] : varaddress = item [ "address" ] print "address: " + varaddress var text = '{"employees":[' + '{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },' + '{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },' + '{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },' + ']} ' ;

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

parse JSON string

jaykapalczynski

I am passing the below from Javascript as a parameter string via a GP Service.

Once I grab this in the python script I am trying to parse it....

I am trying to write variables for address, distance, and id for each record in a for loop....but having issues..thoughts?

<SPAN class="keyword token">for</SPAN> item <SPAN class="keyword token">in</SPAN> textstring<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'employees'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
   varaddress <SPAN class="operator token">=</SPAN>  item<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"address"</SPAN><SPAN class="punctuation token">]</SPAN>
   <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"address: "</SPAN> <SPAN class="operator token">+</SPAN> varaddress<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

<SPAN class="keyword token">var</SPAN> text <SPAN class="operator token">=</SPAN> <SPAN class="string token">'{"employees":['</SPAN> <SPAN class="operator token">+</SPAN>
    <SPAN class="string token">'{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },'</SPAN> <SPAN class="operator token">+</SPAN>
    <SPAN class="string token">'{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },'</SPAN> <SPAN class="operator token">+</SPAN>
    <SPAN class="string token">'{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },'</SPAN> <SPAN class="operator token">+</SPAN>
<SPAN class="string token">']} '</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Trouver plus de publications taguées avec

Accepted answers

jskinner

Hey Jay,

Use json.loads to convert the JSON string to a Python Dictionary.

<SPAN class="keyword token">import</SPAN> json

text <SPAN class="operator token">=</SPAN> <SPAN class="string token">'{"employees":[{"address":"113 Buffalo Rd, Clarksville, VA 23927","distance":"50","id" : "4"},{"address":"8817 Sherando Dr, Bristow, VA 20136","distance":"20","id" : "5" }]}'</SPAN>

textDict <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>loads<SPAN class="punctuation token">(</SPAN>text<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> employee <SPAN class="keyword token">in</SPAN> textDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'employees'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
    varaddress <SPAN class="operator token">=</SPAN>  employee<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"address"</SPAN><SPAN class="punctuation token">]</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>varaddress<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

jaykapalczynski

Yup....syntax just the ' on front and backside.....everything seems to be working.....thank you all for your thoughts and pointers....cheers....stay safe

jaykapalczynski

I think I might have it....I copied the string and remove the ' on the beginning and end and I think I can now pass it as a parameter...

Still testing

jaykapalczynski

One more thing....I am very confused on

I can get this to work from running the python script seen below using the dataInputParameter variable

ALTHOUGH I am trying to run this from a ESRI tool that passes in a parameter

If I change the below code to accept the dataInputParameter1 variable which is the STRING being passed to it from the ESRI Tool it blows up

textDict <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>loads<SPAN class="punctuation token">(</SPAN>dataInputParameter1<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

So I change to the code above

Copy the text from the dataInputParameter variable seen below

Launch the tool and paste that into the parameter and submit it blows up.

BUT as you can see I have a second parameter that returns results....I am returning all 3 Variables seen below...and the ONLY difference is that when I return the 3rd variable (the one that works when I define it) is it missing the single ' on the beginning and end....

QUESTION: do I need to strip the variable that I am grabbing from the GetParametersAsText?????

Why does it work with a manual variable and not the parameter text?

MESSAGE Variable 1: is the dataInputParameter1 variable that is created from the string being passed for the Tool
MESSAGE Variable 2: is the dataInputParameter2 variable simply set form the getParameterAsText variable
MESSAGE Variable 3: is the variable that I create with the text seen below...this is ALSO the text that I copy into the string parameter in the ESRI Tool

dataInputParameter1 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>

dataInputParameter2 <SPAN class="operator token">=</SPAN> dataInputParameter1

dataInputParameter <SPAN class="operator token">=</SPAN> <SPAN class="string token">'{"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50",  "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20",  "id" : "5" }]}'</SPAN>


varaddress <SPAN class="operator token">=</SPAN>  <SPAN class="string token">""</SPAN>
vardistance <SPAN class="operator token">=</SPAN>  <SPAN class="string token">""</SPAN>
varid <SPAN class="operator token">=</SPAN>  <SPAN class="string token">""</SPAN>

textDict <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>loads<SPAN class="punctuation token">(</SPAN>dataInputParameter<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> employee <SPAN class="keyword token">in</SPAN> textDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'employees'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
    varaddress <SPAN class="operator token">=</SPAN>  employee<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"address"</SPAN><SPAN class="punctuation token">]</SPAN>
    vardistance <SPAN class="operator token">=</SPAN>  employee<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"distance"</SPAN><SPAN class="punctuation token">]</SPAN>
    varid <SPAN class="operator token">=</SPAN>  employee<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"id"</SPAN><SPAN class="punctuation token">]</SPAN>

    <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"address: "</SPAN> <SPAN class="operator token">+</SPAN> varaddress<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"distance: "</SPAN> <SPAN class="operator token">+</SPAN> vardistance<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"uniqueid: "</SPAN> <SPAN class="operator token">+</SPAN> varid<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN> <SPAN class="string token">""</SPAN>

msg1 <SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"MESSAGE Variable 1: "</SPAN> <SPAN class="operator token">+</SPAN> dataInputParameter1<SPAN class="punctuation token">)</SPAN>
msg2 <SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"MESSAGE Variable 2: "</SPAN> <SPAN class="operator token">+</SPAN> dataInputParameter2<SPAN class="punctuation token">)</SPAN>
msg3 <SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"MESSAGE Variable 3: "</SPAN> <SPAN class="operator token">+</SPAN> dataInputParameter<SPAN class="punctuation token">)</SPAN>
msg4 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>msg1 <SPAN class="operator token">+</SPAN> msg2 <SPAN class="operator token">+</SPAN> msg3<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN>msg4<SPAN class="punctuation token">)</SPAN>
resultMsg <SPAN class="operator token">=</SPAN> msg4
arcpy<SPAN class="punctuation token">.</SPAN>SetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> resultMsg<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Executing: CreateMultiPolyBatch '{"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50",  "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20",  "id" : "5" }]}'

Start Time: Mon Mar 30 16:08:57 2020
Running script CreateMultiPolyBatch...

MESSAGE Variable 1: '{"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50",  "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20",  "id" : "5" }]}'

MESSAGE Variable 2: '{"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50",  "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20",  "id" : "5" }]}'

MESSAGE Variable 3: {"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9",  "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50",  "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20",  "id" : "5" }]}

Completed script CreateMultiPolyBatch...
Succeeded at Mon Mar 30 16:08:57 2020 (Elapsed Time: 0.11 seconds)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jaykapalczynski

I can get my string to this in python but need to loop through and set each of the items to variables

DATA<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'{"employees":[{"address":"113 Buffalo Rd, Clarksville, VA 23927","distance":"50","id" : "4"},{"address":"8817 Sherando Dr, Bristow, VA 20136","distance":"20","id" : "5" }]} '</SPAN>

JSON<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"{\"employees\":[{\"address\":\"113 Buffalo Rd, Clarksville, VA 23927\",\"distance\":\"50\",\"id\" : \"4\"},{\"address\":\"8817 Sherando Dr, Bristow, VA 20136\",\"distance\":\"20\",\"id\" : \"5\" }]} "</SPAN>

ENCODED<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"{\"employees\":[{\"address\":\"113 Buffalo Rd, Clarksville, VA 23927\",\"distance\":\"50\",\"id\" : \"4\"},{\"address\":\"8817 Sherando Dr, Bristow, VA 20136\",\"distance\":\"20\",\"id\" : \"5\" }]} "</SPAN>

DECODED<SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"employees"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">"address"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"113 Buffalo Rd, Clarksville, VA 23927"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"distance"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"50"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"id"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"4"</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">"address"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"8817 Sherando Dr, Bristow, VA 20136"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"distance"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"20"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"id"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"5"</SPAN> <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">}</SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jskinner

Hey Jay,

Use json.loads to convert the JSON string to a Python Dictionary.

<SPAN class="keyword token">import</SPAN> json

text <SPAN class="operator token">=</SPAN> <SPAN class="string token">'{"employees":[{"address":"113 Buffalo Rd, Clarksville, VA 23927","distance":"50","id" : "4"},{"address":"8817 Sherando Dr, Bristow, VA 20136","distance":"20","id" : "5" }]}'</SPAN>

textDict <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>loads<SPAN class="punctuation token">(</SPAN>text<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> employee <SPAN class="keyword token">in</SPAN> textDict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'employees'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
    varaddress <SPAN class="operator token">=</SPAN>  employee<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"address"</SPAN><SPAN class="punctuation token">]</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>varaddress<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

Are you just trying to parse that string into a dictionary? Use json.loads

import json
data = json.loads(text)
print(data["employees"])

jaykapalczynski

In the original post the first part was in Python the second was in Javascript....that is what I am trying to pass as a parameter to the service and eventually the python scripts

Here is an example of a shortened string

<SPAN class="string token">'{"employees":[{"address":"113 Buffalo Rd, Clarksville, VA 23927","distance":"50","id" : "4"},{"address":"8817 Sherando Dr, Bristow, VA 20136","distance":"20","id" : "5" }]} '</SPAN>
    ‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.