Forum Discussion

swright's avatar
swright
New Contributor III
4 years ago
Solved

Jsonpath - how to use parameters or variables inside a jsonpath

Using jsonpath as the expression in a mapper snap the following works: jsonPath($, “$entity.items[?(@.AssignmentNumber==‘E3163300-2’)].links[*]”).find(x=>x.name == ‘assignedPayrolls’).href I want...
  • j_angelevski's avatar
    j_angelevski
    4 years ago

    Hi @swright,

    You need to concatenate the jsonPath with the pipeline parameter.

    jsonPath($, "$entity.items[?(value.AssignmentNumber=='" + _AssignmentNumber + "')].links[*]").find(x=>x.name == "assignedPayrolls").href
j_angelevski's avatar
j_angelevski
Contributor III
4 years ago

Hi @swright,

You need to concatenate the jsonPath with the pipeline parameter.

jsonPath($, "$entity.items[?(value.AssignmentNumber=='" + _AssignmentNumber + "')].links[*]").find(x=>x.name == "assignedPayrolls").href
  • swright's avatar
    swright
    New Contributor III
    4 years ago

    Thank you! Your solution worked perfectly! I had tried something like that before and it failed. It was probably my syntax but your syntax worked on the first try!