How do I create a JSON property name from a field's data? (4 replies)
To be clear, the JSON on the left of the image is the desired output to be produced from the data on the right.
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.
This is important for a project that I'm working on. Has there been any progress?
Any movement on this?
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.