API not returning all fields
Using REST API I see below.
Given this:
{'id': 'G',
'name': 'Inventory_avail',
'fields': [{'id': 'A', 'name': 'Adj_code', 'type': 'number'},
{'id': 'B', 'name': 'Location', 'type': 'number'},
{'id': 'C', 'name': 'Loc_grid', 'type': 'number'},
{'id': 'D', 'name': 'item_desc', 'type': 'string'},
{'id': 'E', 'name': 'item_no', 'type': 'number'},
{'id': 'F', 'name': 'Category', 'type': 'string'},
{'id': 'H', 'name': 'Date', 'type': 'number'},
{'id': 'I', 'name': 'Comment', 'type': 'number'},
{'id': 'J', 'name': 'Cell_per', 'type': 'number'},
{'id': 'K', 'name': 'Enter_qty', 'type': 'number'}]
Note no 'G' field, though there is one, a calculated field named 'Qty'. This field does show up in the data export though. Why is it not included in field list?
I get a response of:
[{'id': 1823,
'sequence': 400,
'createdAt': '2021-01-15T18:55:27',
'createdBy': 'JqF4dqaYaQYbXjS4a',
'modifiedAt': '2021-01-27T23:56:56',
'modifiedBy': 'JqF4dqaYaQYbXjS4a',
'fields': {'Adj_code': 1,
'Location': 1,
'item_desc': 'Astilbe Younique Ruby Red gallon',
'item_no': 60096,
'Category': 'PEREN G',
'Cell_per': 1,
'Enter_qty': 3}}]
In above only fields with a value show up(not including 'Qty' field). Why aren't all the fields returned?
Reply
Content aside
- 4 yrs agoLast active
- 346Views