Forum Discussion

stephenknilans's avatar
stephenknilans
Contributor
8 years ago

Is there a way to selectively exclude fields output from a mapper snap?

I have a case where many fields may have to be excluded from mapper output, as if they never existed, selectively during a run. I am going to a cloud instance of a routine that will take null values...
dimche_saveski's avatar
dimche_saveski
New Contributor III
6 years ago
Copy LinkReport

Hello @peter

You can use JSON Path to get the Record and sysid in the mapper. Write the path to the sysid location, try this in the mapper jsonPath($, “$entity.result.sysid”).

Best Regards
Dimche Saveski

peter's avatar
peter
New Contributor III
6 years ago
Copy LinkReport

Hi that is great, never thought of that!

Sadly I keep getting an error.

My string is.

[
{
“response”:
{
“statusLine”:
{
“protoVersion”:
“HTTP/1.1”
“statusCode”:
200
“reasonPhrase”:
“OK”
}
“entity”:
“{“result”:{“status”:“success”,“message”:“Requested Item created: RITM1941111”,“record”:“RITM1941111”,“sysid”:“60f3d2eadbe7041001”,“automation_id”:null,“automation_version_id”:null}}”

My command is, jsonPath($,“$response.entity.status.record.sysid”)

“failure”: “Expecting object for JSON-Path field reference ‘status’, found: String”

Thanks for your help.