0

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

null

Content aside

  • 3 yrs agoLast active
  • 336Views