Back to forum list… Back to How Do I?...

How do I create a JSON property name from a field's data? (4 replies)

John G
1 year ago
John G 1 year ago

I am working with an API that associates users with sites. The API takes a set of Site IDs, each of which contains an array of user IDs. The Site IDs are actually properties of the outer JSON object. My dataset has fields site_id and user_id. How do I convert the Site IDs in my data to property names in the JSON output?

Picture attached, which should help to understand the issue.

https://www.realisable.co.uk/wp-content/uploads/2023/10/notepad_2023-10-05_10-36-08.jpg
John G
1 year ago
John G 1 year ago

To be clear, the JSON on the left of the image is the desired output to be produced from the data on the right.

Support
1 year ago
Support 1 year ago

John, there is no present facility to use values in the property names.

To achieve this we would need to add functionality to both the JPath parser and the JSON writer.

We are prepared to make this change, but we would need about 10 days to add.

John G
1 year ago
John G 1 year ago

This is important for a project that I'm working on. Has there been any progress?

John G
12 months ago
John G 12 months ago

Any movement on this?

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close