Json payload extraction is not happening in the Extract Variable policy when it contains @ and .

Google Cloud Apigee
1

Hi,

I am trying to extract below path @odata.nextLink by configuring like $.@odata.nextLink in Extract variable policy but it is not getting extracted. Would any help me the correct path.

Note: @ and . symbols are there in the variable. I thinking this might be the issue.

{
“@odata.context”: “https://google.com/$metadata#users”,
“@odata.nextLink”: “https://google.com/users?$top=999&$skiptoken=RFNwdAIAABU6a2JhbGF3aUB0YXdhbC5jb20uc2Ep”,
“value”: [

2 Likes
2

I think you want to use the jsonpath expression that uses square brackets, like this:

<ExtractVariables name='EV-From-JSON'>
  <Source>message</Source>
  <VariablePrefix>extracted</VariablePrefix>
  <JSONPayload>
    <Variable name='context'>
      <JSONPath>$['@odata.context']</JSONPath>
    </Variable>
    <Variable name='nextLink'>
      <JSONPath>$['@odata.nextLink']</JSONPath>
    </Variable>
  </JSONPayload>
</ExtractVariables>
1 Like
3

@dchiesa1 Thank you so much for your quick response and it is working fine.

2 Likes