I did try the sample payload option but it makes it an object and then gives the error that its expect an array. same issue as posted above.
The JSON has a lot more entries than this one but this is the first 2 results. The only information im interested in getting out is the 'name' (which is a mobile number) and the department.name.
[
{
"custom": null,
"id": 2241709,
"href": "https://api.samanage.com/other_assets/2241709-0400044852.json",
"name": "040555555",
"owner": {
"group_id": 4778498,
"is_user": true,
"id": 4528769,
"name": "Mark Hughes",
"disabled": false,
"title": "Service Technician",
"email": "Mark.Hughes@dummydomain.com",
"created_at": "2019-01-14T03:55:35.000Z",
"updated_at": "2019-01-17T02:37:59.000Z",
"last_login": null,
"phone": "+61 8 1111111",
"mobile_phone": "+61 1111111",
"department": {
"id": 136719,
"name": "NAT Operations",
"description": "",
"default_assignee_id": null
},
"role": {
"id": 454597,
"name": "Requester",
"description": "Requester role to view and submit service request.",
"portal": true,
"show_my_tasks": false
},
"salt": "9413e839d96d40eb16a5ffea019aa5064fb300e4",
"group_ids": [
4778498
],
"custom_fields_values": [],
"site": null,
"avatar": {
"type": "initials",
"color": "#0089c9",
"initials": "MH"
},
"mfa_enabled": false,
"reports_to": {
"group_id": 4708387,
"is_user": true,
"id": 4456475,
"name": "Paul Welland",
"email": "Paul.Welland@dummydomain.com",
"avatar": {
"type": "initials",
"color": "#dfcd00",
"initials": "PW"
},
"default_landing_page": "Last_Page_Viewed"
},
"default_landing_page": "Last_Page_Viewed"
},
"user": null,
"description": "Business BYO Mobile Plan $59",
"asset_id": "ID00628132241709",
"site": null,
"department": {
"id": 162476,
"name": "WA Operations",
"description": "",
"default_assignee_id": null
},
"asset_type": {
"id": 1174939,
"account_id": 62813,
"parent_id": 0,
"name": "Mobile Service"
},
"category": {
"id": 1174939,
"account_id": 62813,
"parent_id": 0,
"name": "Mobile Service"
},
"status": {
"id": 1,
"name": "Operational"
},
"ip_address": "",
"manufacturer": "Telstra",
"model": "SM-J530Y",
"serial_number": "89610180002013438329",
"created_at": "2019-07-22T06:38:50.000Z",
"updated_at": "2019-07-24T02:35:20.000Z",
"address": null,
"tasks": [],
"maintenance_contract": null,
"lease_contract": null,
"incidents": [],
"purchase": null,
"purchase_orders": [],
"tags": [],
"hardware_dates": [
{
"id": 54571378,
"date": "2019-07-22",
"date_type": "Assigned",
"username": "Mark Hughes",
"notes": "[Automatic] Technical contact changed to Mark Hughes",
"user_type": null
},
{
"id": 54680810,
"date": "2019-07-24",
"date_type": "Assigned",
"username": "-1",
"notes": "[Automatic] Assigned to NAT Operations department",
"user_type": null
},
{
"id": 54681521,
"date": "2019-07-24",
"date_type": "Assigned",
"username": null,
"notes": "[Automatic] Assigned to WA Operations department",
"user_type": null
}
],
"latitude": null,
"longitude": null,
"custom_fields_values": [
{
"id": 93958397,
"custom_field_id": 106086,
"name": "Tag Printed",
"value": "0",
"options": "",
"type": 3,
"type_name": "Checkbox",
"show_on_portal": false,
"mandatory": false,
"user": null
}
]
},
{
"custom": null,
"id": 2241727,
"href": "https://api.samanage.com/other_assets/2241727-0400341597.json",
"name": "0400555555",
"owner": {
"group_id": 4556896,
"is_user": true,
"id": 4305128,
"name": "Prabha Srinivasan",
"disabled": false,
"title": "Senior Application Engineer",
"email": "Prabha.Srinivasan@dummydomain.com",
"created_at": "2018-12-21T01:59:05.000Z",
"updated_at": "2019-07-24T03:27:32.000Z",
"last_login": "2019-02-14T06:49:40.000Z",
"phone": "+61 8 81111111",
"mobile_phone": "+61 1111111",
"department": {
"id": 162468,
"name": "Proposals",
"description": "",
"default_assignee_id": null
},
"role": {
"id": 454597,
"name": "Requester",
"description": "Requester role to view and submit service request.",
"portal": true,
"show_my_tasks": false
},
"salt": "9d04c42ffa99b5e11f5f5a515eb8572ed2015737",
"group_ids": [
4556896,
4555151,
4555156
],
"custom_fields_values": [],
"site": null,
"avatar": {
"type": "initials",
"color": "#2eabcf",
"initials": "PS"
},
"mfa_enabled": false,
"reports_to": {
"group_id": 4556836,
"is_user": true,
"id": 4305068,
"name": "Brionne Gay",
"email": "Brionne.Gay@dummydomain.com",
"avatar": {
"type": "initials",
"color": "#fa7911",
"initials": "BG"
},
"default_landing_page": "Last_Page_Viewed"
},
"default_landing_page": "Last_Page_Viewed"
},
"user": null,
"description": "Business BYO Mobile Plan $59",
"asset_id": "ID00628132241727",
"site": null,
"department": {
"id": 162468,
"name": "Proposals",
"description": "",
"default_assignee_id": null
},
"asset_type": {
"id": 1174939,
"account_id": 62813,
"parent_id": 0,
"name": "Mobile Service"
},
"category": {
"id": 1174939,
"account_id": 62813,
"parent_id": 0,
"name": "Mobile Service"
},
"status": {
"id": 1,
"name": "Operational"
},
"ip_address": "",
"manufacturer": "Telstra",
"model": "A1778",
"serial_number": "89610180001753395352",
"created_at": "2019-07-22T06:38:53.000Z",
"updated_at": "2019-07-24T02:42:04.000Z",
"address": null,
"tasks": [],
"maintenance_contract": null,
"lease_contract": null,
"incidents": [],
"purchase": null,
"purchase_orders": [],
"tags": [],
"hardware_dates": [
{
"id": 54571390,
"date": "2019-07-22",
"date_type": "Assigned",
"username": "Prabha Srinivasan",
"notes": "[Automatic] Technical contact changed to Prabha Srinivasan",
"user_type": null
},
{
"id": 54681529,
"date": "2019-07-24",
"date_type": "Assigned",
"username": "-1",
"notes": "[Automatic] Assigned to NAT Projects department",
"user_type": null
},
{
"id": 54681589,
"date": "2019-07-24",
"date_type": "Assigned",
"username": null,
"notes": "[Automatic] Assigned to Proposals department",
"user_type": null
}
],
"latitude": null,
"longitude": null,
"custom_fields_values": [
{
"id": 93958798,
"custom_field_id": 106086,
"name": "Tag Printed",
"value": "0",
"options": "",
"type": 3,
"type_name": "Checkbox",
"show_on_portal": false,
"mandatory": false,
"user": null
}
]
},
]