Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Help needed differentiating similar named fields in jSON results with REST API
Hi,
When I do a non basic REST API query like :
SELECT * FROM transactionline tl, transaction t, customer c WHERE transaction > 123 and tl.transaction = t.id and t.entity = c.id"
The result comes back with similar named fields like:
"currency" : "xxx",
"currency_0" : "xxx",
"entity" : "xxx",
"entity_0" : "xxx",
"id" : "xxx",
"id_0" : "xxx",
"id_1" : "xxx",
"lastmodifieddate" : "xxx",
"lastmodifieddate_0" : "xxx",
Q: Is there some way that I can know which field belongs to which table?
like:
"id" : "xxx" - "id_0" : "xxx" - "id_1" : "xxx" belongs to transactionline or transaction or customer?
How can I tell what field is what table?