Has anyone successfully used the Transform JSON function?
I have a column of JSON data that is pulled from an API and I just need to parse a portion of that data into a form that’s useful for my app. The Transform JSON with JQ did exactly what I needed. . . briefly. Sometimes it will transform the data perfectly but then will disappear. But usually it just does nothing and appears to choke on the data. The fields are empty but when I scroll the table, cells will briefly show an icon that appears to indicate that it’s attempting to process.
The JSON isn’t exceptionally long or complex. Here’s an example:
[{“amount”:423,“commission_amount”:0,“description”:“Rent”,“is_channel_managed”:true,“is_commission_all”:false,“is_expense_all”:false,“is_taxable”:true,“owner_amount”:423,“owner_commission_percent”:0,“position”:0,“rate”:423,“rate_is_percent”:false,“type”:“rent”},{“amount”:70,“commission_amount”:0,“description”:“Cleaning Fee”,“is_channel_managed”:true,“is_commission_all”:false,“is_expense_all”:false,“is_taxable”:true,“owner_amount”:70,“owner_commission_percent”:0,“position”:1,“rate”:70,“rate_is_percent”:false,“surcharge_id”:102548908,“type”:“surcharge”}]
… and the JQ query seems pretty simple:
. | .description, .amount
I thought it might be choking because my table had 400 rows. But I tested it on a table with just a single row and got the same results.
