Question

Single quote (apostrophe) in published parameter when submitting a job through FME REST

  • 7 October 2022
  • 2 replies
  • 11 views
nielsgerrits
Rank
Userlevel 6
Badge +33

We have a workspace on FME server (2021.2.6) with a published parameter ProjectName.

We're submitting jobs through the REST enpoint, using json for the parameters.

Now we have a project name with an single quote (apostrophe), like:

A'dam

This results in a code 400 - bad request.

 

So, what is the correct way to send this string in the json? What we have tried:

A%27dam

This works, but then we need to decode the string in workbench.

A\'dam

This works, but server interprets this as as a double quote.

A"dam

We also tried to replicate this in submitting a job from the fme server interface but then the parameters are sent as form data, not as json...

2 replies

merlinegeorge
Rank
Badge +5

Hello @nielsgerrits​ ,

 

Could you please test if this works- To use an apostrophe or a single quotation mark (') in a value, add another single quotation mark after the first one.

For example - the value O'Hara can be submitted as  "O''HARA".

nielsgerrits
Rank
Userlevel 6
Badge +33

Hello @nielsgerrits​ ,

 

Could you please test if this works- To use an apostrophe or a single quotation mark (') in a value, add another single quotation mark after the first one.

For example - the value O'Hara can be submitted as  "O''HARA".  

Hej @Merline George​ , thanks for looking into this. I tried replacing a single quote with 2 single quotes:

{
	"TMDirectives": {
		"ttl": 60,
		"description": "",
		"priority": 100,
		"tag": "Normal"
	},
	"publishedParameters": [
		{
			"name": "ProjectNaam",
			"value": "A''dam"
		}
	],
	"subsection": "REST_SERVICE"
}

But I still get

The remote server returned an error: (400) Bad Request.

when submitting the job. We initiate the job using /fmerest/v3/transformations/submit/.

Reply


Community Stats

28,724
Posts
109,519
Replies
36,564
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.