cancel
Showing results for 
Search instead for 
Did you mean: 

How to get id column value

Rahul
New Contributor III

“entity”: “{"columns": "created_at,carrier_name,tracking_number,status_caption,locker.locker_number,status_timestamp,assigned_name,recipient_name,recipient_location_full_name,location_full_name,sender_name,comments,is_damaged,modified_by_name,custom_field_values.23,custom_field_values.26,custom_field_values.15,custom_field_values.25,custom_field_values.5,recipient_contact_custom_field_values.6,recipient_contact_custom_field_values.16,recipient_contact_custom_field_values.24,recipient_contact_custom_field_values.29,sender_contact_custom_field_values.6,sender_contact_custom_field_values.16,sender_contact_custom_field_values.24,sender_contact_custom_field_values.29", "content_type": "text/csv", "filter": "", "filter_description": "", "filter_location_id": null, "id": 95, "last_run_at": "Wed, 15 Dec 2021 09:40:43 GMT", "modified_at": "Wed, 15 Dec 2021 09:40:43 GMT", "modified_by": 1, "name": "rahul2", "owner_id": 1, "path": null, "row_count": 0, "search": null, "sort": null, "status": 1, "type": 0}”

6 REPLIES 6

SpiroTaleski
Valued Contributor

@Rahul

Try $entity.id or $entity.get(“id”)

Regards,
Spiro Taleski

Rahul
New Contributor III

@Spiro_Taleski I tried but it’s not working

SpiroTaleski
Valued Contributor

@Rahul

Can you please attach whole JSON document from where you want to get that “id” field?
Since, the way how currently you pasted the JSON message is really hard to analyze.

Regards,
Spiro Taleski

Rahul
New Contributor III

[
{
“response”: {
“statusLine”: {
“protoVersion”: “HTTP/1.1”,
“statusCode”: 201,
“reasonPhrase”: “CREATED”
},
“entity”: “{"columns": "created_at,carrier_name,tracking_number,status_caption,locker.locker_number,status_timestamp,assigned_name,recipient_name,recipient_location_full_name,location_full_name,sender_name,comments,is_damaged,modified_by_name,custom_field_values.23,custom_field_values.26,custom_field_values.15,custom_field_values.25,custom_field_values.5,recipient_contact_custom_field_values.6,recipient_contact_custom_field_values.16,recipient_contact_custom_field_values.24,recipient_contact_custom_field_values.29,sender_contact_custom_field_values.6,sender_contact_custom_field_values.16,sender_contact_custom_field_values.24,sender_contact_custom_field_values.29", "content_type": "text/csv", "filter": "", "filter_description": "", "filter_location_id": null, "id": 95, "last_run_at": "Wed, 15 Dec 2021 09:40:43 GMT", "modified_at": "Wed, 15 Dec 2021 09:40:43 GMT", "modified_by": 1, "name": "rahul2", "owner_id": 1, "path": null, "row_count": 0, "search": null, "sort": null, "status": 1, "type": 0}”,
“headers”: {
“content-length”: “998”,
“x-frame-options”: “DENY”,
“connection”: “keep-alive”,
“cache-control”: “no-store, no-cache”,
“x-pb-api-time-taken-ms”: “74.3”,
“content-type”: “text/html; charset=utf-8”,
“x-app-version”: “3812”,
“server”: “nginx/1.20.0”,
“date”: “Wed, 15 Dec 2021 09:40:43 GMT”,
“expires”: “0”,
“x-pb-supportcode”: “603-519”
}
},
“original”: {
“name”: “rahul2”,
“filter”: “”,
“filter_description”: “”,
“content_type”: “text/csv”,
“columns”: “created_at,carrier_name,tracking_number,status_caption,locker.locker_number,status_timestamp,assigned_name,recipient_name,recipient_location_full_name,location_full_name,sender_name,comments,is_damaged,modified_by_name,custom_field_values.23,custom_field_values.26,custom_field_values.15,custom_field_values.25,custom_field_values.5,recipient_contact_custom_field_values.6,recipient_contact_custom_field_values.16,recipient_contact_custom_field_values.24,recipient_contact_custom_field_values.29,sender_contact_custom_field_values.6,sender_contact_custom_field_values.16,sender_contact_custom_field_values.24,sender_contact_custom_field_values.29”,
“type”: 0
}
}
]