jaykapalczynski
by
Honored Contributor
‎03-30-2020 01:13 PM

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 = json.loads(dataInputParameter1)‍

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 = arcpy.GetParameterAsText(0)

dataInputParameter2 = dataInputParameter1

dataInputParameter = '{"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" }]}'


varaddress =  ""
vardistance =  ""
varid =  ""

textDict = json.loads(dataInputParameter)

for employee in textDict['employees']:
    varaddress =  employee["address"]
    vardistance =  employee["distance"]
    varid =  employee["id"]

    print ("address: " + varaddress)
    print ("distance: " + vardistance)
    print ("uniqueid: " + varid)
    print ""

msg1 =("MESSAGE Variable 1: " + dataInputParameter1)
msg2 =("MESSAGE Variable 2: " + dataInputParameter2)
msg3 =("MESSAGE Variable 3: " + dataInputParameter)
msg4 = (msg1 + msg2 + msg3)
arcpy.AddMessage(msg4)
resultMsg = msg4
arcpy.SetParameterAsText(1, resultMsg)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

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)‍‍‍‍‍‍‍‍‍‍‍‍‍
0 Kudos