I'm trying to define some user parameters using scripted parameters. I've written a python script that loads a JSON from a url into a dictionary then extracts the value for defined key. My Private Parameter is called classField.
It works fine when I run it from my Python IDE but not in workbench. What do I need to add/remove to make it work in workbench? I'm using FME 2012 and this is my code:
import simplejson
import urllib2
from pprint import pprint
import sys
import __main__
def URLjson2dictionary(url):
'''Reads json from url and loads it into a python dictionary'''
try:
# open the url (json string) and load into python dictionary
json_dict = simplejson.load(urllib2.urlopen(url))
except Exception as e:
print 'Could not load json from URL. Error: {0}'.format(e)
raise # reraises the exception
return json_dict
def dictValueFetcher(dict, key):
'''Returns the value for a specified key from the python dictionary'''
if key in dict:
return dict.get(key)
else:
print 'Key not in dictionary'
sys.exit()
if __name__ == '__main__':
# define input parameters
url = "http://www.ga.gov.au/gis/rest/services/topography/Australian_Topography/MapServer?f=pjson"
# load the json into a dictionary object
json_data = URLjson2dictionary(url)
# print dictionary derived from json in nice readable format
print 'json_data:'
pprint(json_data)
# Get the parameter value from the dictionary
FME_parameter_value = dictValueFetcher(json_data, "mapName")
print 'KeyFME_parameter_value: {0}'.format(FME_parameter_value)
This is the Log:
Windows command-line to run this workspace: fme.exe CIAP_SBAGDdataValidatorVerson3.fmw --SourceDataset_GEODATABASE_SDE sde --DestDataset_GEODATABASE_FILE C:\\CIAP\\FME_Server\\CIAPStagingDB.gdb --DestDataset_JSON C:\\CIAP\\FME_Server\\DataLoadValidation_working\\InvalidGeomFeatures.json Starting Translation ... INCLUDE -- failed to evaluate Python script `def ParamFunc(): import simplejson import urllib2 from pprint import pprint import sys import __main__ def URLjson2dictionary(url): '''Reads json from url and loads it into a python dictionary''' try: # open the url (json string) and load into python dictionary json_dict = simplejson.load(urllib2.urlopen(url)) except Exception as e: print 'Could not load json from URL. Error: {0}'.format(e) # send error message somewhere else # send_somewhere(traceback.format_exception(*sys.exc_info())) raise # reraises the exception return json_dict def dictValueFetcher(dict, key): '''Returns the value for a specified key from the python dictionary''' if key in dict: return dict.get(key) else: print 'Key not in dictionary' sys.exit() if __name__ == '__main__': # define input parameters url = "http://www.ga.gov.au/gis/rest/services/topography/Australian_Topography/MapServer?f=pjson" # load the json into a dictionary object json_data = URLjson2dictionary(url) # print dictionary derived from json in nice readable format print 'json_data:' pprint(json_data) # Get the parameter value from the dictionary FME_parameter_value = dictValueFetcher(json_data, "mapName") return print 'KeyFME_parameter_value: {0}'.format(FME_parameter_value) value = ParamFunc() macroName = 'classField' if value == None: return { macroName : '' } else: return { macroName : str(value) } ' Program Terminating Translation FAILED.
If the scripting path is not the best method, any suggested workarounds would be greatly appreciated too.
Thanks
Rob
