Forum Discussion

Rahul's avatar
Rahul
New Contributor III
4 years ago

How to get id column value

“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}”

pipeline

6 Replies

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    4 years ago

    @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's avatar
    Rahul
    New Contributor III
    4 years ago

    [
    {
    “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
    }
    }
    ]