How to retrieve data from JSON file when the fields include white spaces in them

This article helps in getting the data from the JSON files for the fields which have white spaces included in them.

Instructions

1. Log in to Confluence.
2. Insert the JSON Table macro in a Confluence page.
3. Input the JSON data through the Method of locating script or follow the instructions mentioned in the Build an Advanced Table from Rest API Data 8.x article and save the macro settings.

4. The article in Step 3 i.e., Build an Advanced Table from Rest API Data 8.x  works fine if the field names in the JSON data don't have any white spaces included in them.

5. If there are any white spaces included, for example, as shown in the JSON data below, the fields App Name and Product Category, one might observe the error as Error rendering macro json-table: Space not allowed in path. Refer the screenshot attached.

   [{"Tools":["Both"],"Role":["Support Engineer"],"Name":["K S"],"User":["test.user"],"App Name":["Bobswift"],"Product Category":["BI reporting"]}]

   
   
   
   
   

6. To avoid this error and to render the data by escaping the white spaces, the field names should be given as ['App Name'],['Product Category'], then the results are as shown below
   
   
   
   
7. Save the settings and Publish the page.