Skip to main content
Question

Json attributes with dollar sign

M
Data Enthusiast
Forum|alt.badge.img

We have some json which contains dollar signs e.g.

1{
2  "$guid": "2d5f7c9c-8e72-4f23-9538-8e07d4c5dcbc",
3  "user": {
4    "name": "Alice",
5    "$guid": "e891cba7-5565-4c48-a2e1-02cd07f81f54"
6  },
7  "orders": [
8    {
9      "$guid": "77e4e751-80e8-470e-92c6-493361a9484f",
10      "total": 100.50
11    },
12    {
13      "$guid": "b1263c77-4e5f-4c1e-88e0-6df67ee99f61",
14      "total": 250.00
15    }
16  ]
17}

I can’t get the json call step to read the $guid attribute as it just says invaild json path. Is there any work around to this?

Did this topic help you find an answer to your question?

4 replies

Phil Holbrook
Ataccamer
Forum|alt.badge.img+1

Hi ​@monkmachine 

The $ character is reserved in the json path specification because it refers to the root element. In this sense it is a “special character”

If you need to use special characters in a json path then you need to surround that whole path specification in double-quotes:

I set this up in a json parser (in vn 15.4.1) rather than a json call because obviously I don’t have your online service - but it should work the same.

M
A
2 people like this
  • M
    monkmachine
  • A
    Ataccama Community Admin
M
Data Enthusiast
Forum|alt.badge.img
  • monkmachineData Enthusiast
  • Author
  • Data Enthusiast
  • 2 replies
  • July 8, 2025

Thanks ​@Phil Holbrook 

Unfortunately this doesn’t work on version 12.6.3 :(

Phil Holbrook
Ataccamer
Forum|alt.badge.img+1

Ah.  Can’t say I’m surprised, sadly - and that version is a long way out of support.  Are you likely to upgrade in the near future? Full support for all characters inside quotes in json path was implemented in version 15.4.1, although the dollar character may have been supported earlier.

 

M
1 person likes this
  • M
    monkmachine
M
Data Enthusiast
Forum|alt.badge.img
  • monkmachineData Enthusiast
  • Author
  • Data Enthusiast
  • 2 replies
  • July 8, 2025

​@Phil Holbrook I’ll ask the question but not hopeful. Thank you for taking time to answer. 

Reply


Most Liked this week

Community Terms of Use & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings