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
- 352Views
