My main question is How do I handle a response value that contains a table of values but is also variable itself and not just a value label/name?
For example Like I have colored red in my response code below:
{
"results": {
"jobcodes": {
"21358474": {
"id": 21358474,
"parent_id": 0, ........
I assume that is what is holding up the filling out my BOs and Attributes with all of my response data.
Here is the JSON response:
Code: Select all
{
"results": {
"jobcodes": {
[color=#FF0000]"21358474": {[/color]
"id": 21358474,
"parent_id": 0,
"assigned_to_all": false,
"billable": false,
"active": true,
"type": "regular",
"has_children": false,
"billable_rate": 0,
"short_code": "",
"name": "1 CASH CUSTOMER ACCOUNT",
"last_modified": "2020-01-24T20:00:39+00:00",
"created": "2019-10-28T22:56:24+00:00",
"project_id": 0,
"filtered_customfielditems": "",
"required_customfields": [
],
"locations": [
],
"geofence_config_id": 0
},
"5868600": {
"id": 5868600,
"parent_id": 0,
"assigned_to_all": true,
"billable": false,
"active": true,
"type": "regular",
"has_children": false,
"billable_rate": 0,
"short_code": "",
"name": "100",
"last_modified": "2020-02-28T21:47:03+00:00",
"created": "2017-07-12T20:05:02+00:00",
"project_id": 0,
"filtered_customfielditems": "",
"required_customfields": [
],
"locations": [
5181629
],
"geofence_config_id": 0
},
"19845277": {
"id": 19845277,
"parent_id": 0,
"assigned_to_all": false,
"billable": false,
"active": true,
"type": "regular",
"has_children": false,
"billable_rate": 0,
"short_code": "",
"name": "101-Admin",
"last_modified": "2019-06-03T22:15:31+00:00",
"created": "2019-04-15T23:21:09+00:00",
"project_id": 0,
"filtered_customfielditems": "",
"required_customfields": [
],
"locations": [
],
"geofence_config_id": 0
}
}
},
"more": true,
"supplemental_data": {
"locations": {
"5181629": {
"id": 5181629,
"addr1": "100 Commercial Ln",
"addr2": "",
"city": "Pineville",
"state": "MO",
"zip": "64856",
"formatted_address": "100 Commercial Ln, Pineville, MO 64856",
"country": "US",
"active": true,
"latitude": 36.507632600000001,
"longitude": -94.278914499999999,
"place_id": "",
"place_id_hash": "53c49817e3cd542e82bbca58ff8eff7d",
"label": "100",
"notes": "",
"geocoding_status": "complete",
"created": "2019-04-15T23:21:09+00:00",
"last_modified": "2019-04-15T23:21:12+00:00",
"geofence_config_id": null,
"linked_objects": {
"jobcodes": [
5868600
]
}
}
}
}
}
I only get data in these objects/attributes:
TSheetsResponse
TSheetsResponse.results (Reference Object)
TSheetsResponse.more (true/false attribute)
TSheetsResponse.supplemental_data (Reference Object)