Re: Get value of JSON

2016-08-05 Thread Mike Bonner
While i'm not yet good at reading json directly, i'm guessing mergeJson works similarly to the built in json library, so I shoved your first sample into a field and did the following in the message box. put jsonimport(field 1) into tdat; put the keys of tdat >From that first example, it looks lik

Re: Get value of JSON

2016-08-05 Thread Skip Kimpel
Further correction (sorry!) There were some more levels to the JSON file... Still trying to get the total_count value as well value from item 1/2 which is the email address: {"status":200,"response":{"entries":[{"1.6":"LName","transaction_id":null,"6":"","payment_date":null,"4":"This is just a tes

Re: Get value of JSON

2016-08-05 Thread Skip Kimpel
Clarification: I am looking to get the total_count value from this sample JSON file: {"entries":[{"payment_date":null,"transaction_id":null,"6":"","1.6":"LName","payment_method":null,"is_fulfilled":null,"form_id":2,"status":"active","post_id":null,"4":"This is just a test","is_starred":0,"transac

Get value of JSON

2016-08-05 Thread Skip Kimpel
Good morning LC'ers! I have been able to successfully user mergJson to create a treeview of my JSON data, but I have a quick question: If I wanted to get a specific value, several "levels" deep, how would I format that that code? Thank you for your help! SKIP ___