<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to pass special characters to geoprocessing tool to create subsequent tasks in workflow? in ArcGIS Workflow Manager Questions</title>
    <link>https://community.esri.com/t5/arcgis-workflow-manager-questions/how-to-pass-special-characters-to-geoprocessing/m-p/183053#M401</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;TABLE style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; font-size: 13px;"&gt;&lt;TBODY style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;TR style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;TD class="" style="border: 0px; font-weight: inherit; font-size: inherit; padding: 0px 15px 0px 0px;"&gt;&lt;DIV class="" style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;SPAN class="" style="color: #6a737c; border: 0px; font-weight: inherit; font-size: 20px; margin: 8px 0px;"&gt;1&lt;/SPAN&gt;&lt;A style="color: #358daa; border: 0px; font-weight: inherit; text-decoration: none; text-indent: -9999em; font-size: 1px; margin: 0px auto 10px;" title="This question does not show any research effort; it is unclear or not useful"&gt;down vote&lt;/A&gt;&lt;A href="https://gis.stackexchange.com/questions/257515/how-to-pass-special-characters-to-geoprocessing-tool/257518" style="color: #358daa; border: 0px; font-weight: inherit; text-decoration: none; text-indent: -9999em; font-size: 1px; margin: 0px auto 2px;" title="Click to mark as favorite question (click again to undo)"&gt;favorite&lt;/A&gt;&lt;DIV class="" style="border: 0px; font-weight: inherit; font-size: inherit;"&gt; &lt;/DIV&gt;&lt;/DIV&gt;&lt;/TD&gt;&lt;TD class="" style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;DIV style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;DIV class="" style="border: 0px; font-weight: inherit; margin: 0px 0px 5px;"&gt;&lt;P style="border: 0px; font-weight: inherit; font-size: inherit; margin: 0px 0px 1em;"&gt;I have a geoprocessing service to create various tasks. So the paarmeters for JTXSteps.ExecuteGPTool are here /addjobcomment&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;CODE style="background-color: #eff0f1; border: 0px; font-weight: inherit; font-size: 13px; padding: 1px 5px;"&gt;&lt;SPAN&gt;/url:"&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fxyz%2Farcgis%2Frest%2Fservices%2FF2F_Workflow%2FTask%2FGPServer%2FCreateTask%2FsubmitJob%3Fjob_type_name%3Ddrafting%26job_name%3D%5BJOB%3ANAME%5D%26description%3D%26owned_by%3D%5BJOB%3AOWNED_BY%5D%26assigned_to%3D%5BJOBEX%3AWSP_TASK.DRAFTING_ROLE%5D%26project_job_id%3D%5BJOB%3APARENT_JOB%5D%26initiator_job_id%3D%5BJOBEX%3AINITIATOR_JOB_ID%5D....%26f%3Dpjson" rel="nofollow" target="_blank"&gt;https://xyz/arcgis/rest/services/F2F_Workflow/Task/GPServer/CreateTask/submitJob?job_type_name=drafting&amp;amp;job_name=[JOB:NAME]&amp;amp;description=&amp;amp;owned_by=[JOB:OWNED_BY]&amp;amp;assigned_to=[JOBEX:WSP_TASK.DRAFTING_ROLE]&amp;amp;project_job_id=[JOB:PARENT_JOB]&amp;amp;initiator_job_id=[JOBEX:INITIATOR_JOB_ID]....&amp;amp;f=pjson&lt;/A&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/P&gt;&lt;P style="border: 0px; font-weight: inherit; font-size: inherit; margin: 0px 0px 1em;"&gt;I have a requirement now to pass this string !@#$%^&amp;amp;*()_+/;:"',.?][}{| as job name essentially to capture all possible special characters in other systems for project names. I have noticed '#' breaks the sequence of parameters and with '&amp;amp;' rest of the string for the Job_name gets ignored. The call to submit GP jobs are expected through workflows and parameters are being read from SQL server tables for subsequent tasks.&lt;/P&gt;&lt;P style="border: 0px; font-weight: inherit; font-size: inherit; margin: 0px 0px 1em;"&gt;In JTX_HISTORY I see the message like these :&lt;/P&gt;&lt;P style="border: 0px; font-weight: inherit; font-size: inherit; margin: 0px 0px 1em;"&gt;Create Plan Checking Task From Drafting (1021423),Working,4,0,. Failed execution: Invalid column value [DESCRIPTION]&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 06 Oct 2017 14:14:46 GMT</pubDate>
    <dc:creator>DeeptiPuri2</dc:creator>
    <dc:date>2017-10-06T14:14:46Z</dc:date>
    <item>
      <title>How to pass special characters to geoprocessing tool to create subsequent tasks in workflow?</title>
      <link>https://community.esri.com/t5/arcgis-workflow-manager-questions/how-to-pass-special-characters-to-geoprocessing/m-p/183053#M401</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;TABLE style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; font-size: 13px;"&gt;&lt;TBODY style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;TR style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;TD class="" style="border: 0px; font-weight: inherit; font-size: inherit; padding: 0px 15px 0px 0px;"&gt;&lt;DIV class="" style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;SPAN class="" style="color: #6a737c; border: 0px; font-weight: inherit; font-size: 20px; margin: 8px 0px;"&gt;1&lt;/SPAN&gt;&lt;A style="color: #358daa; border: 0px; font-weight: inherit; text-decoration: none; text-indent: -9999em; font-size: 1px; margin: 0px auto 10px;" title="This question does not show any research effort; it is unclear or not useful"&gt;down vote&lt;/A&gt;&lt;A href="https://gis.stackexchange.com/questions/257515/how-to-pass-special-characters-to-geoprocessing-tool/257518" style="color: #358daa; border: 0px; font-weight: inherit; text-decoration: none; text-indent: -9999em; font-size: 1px; margin: 0px auto 2px;" title="Click to mark as favorite question (click again to undo)"&gt;favorite&lt;/A&gt;&lt;DIV class="" style="border: 0px; font-weight: inherit; font-size: inherit;"&gt; &lt;/DIV&gt;&lt;/DIV&gt;&lt;/TD&gt;&lt;TD class="" style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;DIV style="border: 0px; font-weight: inherit; font-size: inherit;"&gt;&lt;DIV class="" style="border: 0px; font-weight: inherit; margin: 0px 0px 5px;"&gt;&lt;P style="border: 0px; font-weight: inherit; font-size: inherit; margin: 0px 0px 1em;"&gt;I have a geoprocessing service to create various tasks. So the paarmeters for JTXSteps.ExecuteGPTool are here /addjobcomment&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;CODE style="background-color: #eff0f1; border: 0px; font-weight: inherit; font-size: 13px; padding: 1px 5px;"&gt;&lt;SPAN&gt;/url:"&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fxyz%2Farcgis%2Frest%2Fservices%2FF2F_Workflow%2FTask%2FGPServer%2FCreateTask%2FsubmitJob%3Fjob_type_name%3Ddrafting%26job_name%3D%5BJOB%3ANAME%5D%26description%3D%26owned_by%3D%5BJOB%3AOWNED_BY%5D%26assigned_to%3D%5BJOBEX%3AWSP_TASK.DRAFTING_ROLE%5D%26project_job_id%3D%5BJOB%3APARENT_JOB%5D%26initiator_job_id%3D%5BJOBEX%3AINITIATOR_JOB_ID%5D....%26f%3Dpjson" rel="nofollow" target="_blank"&gt;https://xyz/arcgis/rest/services/F2F_Workflow/Task/GPServer/CreateTask/submitJob?job_type_name=drafting&amp;amp;job_name=[JOB:NAME]&amp;amp;description=&amp;amp;owned_by=[JOB:OWNED_BY]&amp;amp;assigned_to=[JOBEX:WSP_TASK.DRAFTING_ROLE]&amp;amp;project_job_id=[JOB:PARENT_JOB]&amp;amp;initiator_job_id=[JOBEX:INITIATOR_JOB_ID]....&amp;amp;f=pjson&lt;/A&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/P&gt;&lt;P style="border: 0px; font-weight: inherit; font-size: inherit; margin: 0px 0px 1em;"&gt;I have a requirement now to pass this string !@#$%^&amp;amp;*()_+/;:"',.?][}{| as job name essentially to capture all possible special characters in other systems for project names. I have noticed '#' breaks the sequence of parameters and with '&amp;amp;' rest of the string for the Job_name gets ignored. The call to submit GP jobs are expected through workflows and parameters are being read from SQL server tables for subsequent tasks.&lt;/P&gt;&lt;P style="border: 0px; font-weight: inherit; font-size: inherit; margin: 0px 0px 1em;"&gt;In JTX_HISTORY I see the message like these :&lt;/P&gt;&lt;P style="border: 0px; font-weight: inherit; font-size: inherit; margin: 0px 0px 1em;"&gt;Create Plan Checking Task From Drafting (1021423),Working,4,0,. Failed execution: Invalid column value [DESCRIPTION]&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 06 Oct 2017 14:14:46 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-workflow-manager-questions/how-to-pass-special-characters-to-geoprocessing/m-p/183053#M401</guid>
      <dc:creator>DeeptiPuri2</dc:creator>
      <dc:date>2017-10-06T14:14:46Z</dc:date>
    </item>
    <item>
      <title>Re: How to pass special characters to geoprocessing tool to create subsequent tasks in workflow?</title>
      <link>https://community.esri.com/t5/arcgis-workflow-manager-questions/how-to-pass-special-characters-to-geoprocessing/m-p/183054#M402</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello Deepti,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Sorry for the delay. Did you mean to use&amp;nbsp;&lt;SPAN style="color: #242729; background-color: rgba(248, 248, 248, 0.6);"&gt;JTXSteps.ExecuteURL instead of&amp;nbsp;&lt;SPAN&gt;JTXSteps.ExecuteGPTool to run the GP service? If so I don't think all the special characters are accepted in the arguments as part of URL without encoded.&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Would it be possible if you can run this step by executing a GP tool instead of GP service? That way passing special characters would not raise the issue. Also I think there should be a possibility to write a custom token parser for the url if you are using WMX Desktop version (10.x) not Pro.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Let me know how you think of my suggestions. I&amp;nbsp;would like to provide more details&amp;nbsp;if you prefers using GP service and would like to write a token parser.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Meggie&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 29 Nov 2017 19:01:41 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-workflow-manager-questions/how-to-pass-special-characters-to-geoprocessing/m-p/183054#M402</guid>
      <dc:creator>XiaomengZheng</dc:creator>
      <dc:date>2017-11-29T19:01:41Z</dc:date>
    </item>
  </channel>
</rss>

