Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Connector Improvement: ZIP Connector enhancement

Answered
Himanshu Jain User

We are using ZIP connector and need below tables which are as of now missing - 

  • queues 
  • tax_codes
  • comments

Also, we have some critical fields in invoice line items data, which aren't coming - 

  • attributes, amortization etc.

We need urgent support on these.

Sharing below entire output of invoice API

{
  "id": "0d3e3ff7-8152-8080-8760-01956923a74d",
  "type": "invoice",
  "source": null,
  "created_at": 1759326450,
  "withholding_tax_amount": "0.00",
  "invoice_number": "UHXKVMYK-0001",
  "invoice_date": "2025-09-30",
  "due_date": 1763078400,
  "amount": "1000000.00",
  "shipping_amount": "0.00",
  "tax_amount": "0.00",
  "standard_tax_amount": "0.00",
  "description": "UAT Test Scrip E2E-001.1",
  "misc_amount": "0.00",
  "invoice_id": "270",
  "currency": "USD",
  "vendor": {
    "id": "0688d9cb-819b-7884-8000-e247c0c15cbe",
    "type": "vendor",
    "name": "ZipHQ, Inc.",
    "external_data": [
      {
        "id": "658355",
        "source": "netsuite",
        "reference_id": null
      }
    ]
  },
  "location": {
    "id": "0d06ceab-db7b-8600-8b80-01956b771971",
    "type": "location",
    "name": "AMER"
  },
  "line_items": [
    {
      "id": "0d3e4078-458f-8a00-8a40-019569eaf582",
      "type": "line_item",
      "total": "1000000",
      "amortization_start_date": null,
      "secondary_line_type": null,
      "start_date_iso": "2025-10-01",
      "end_date_iso": "2025-10-31",
      "amortization_end_date": null,
      "tax_amount": "0",
      "quantity": "1",
      "rate": "1000000",
      "line_type": 1,
      "description": "catherine test",
      "end_date": 1761868800,
      "start_date": 1759276800,
      "item_account": null,
      "expense_category": null,
      "tax_codes": [],
      "location": {
        "id": "0d06ceab-db7b-8600-8b80-01956b771971",
        "type": "location",
        "name": "AMER"
      },
      "department": {
        "id": "0687fbf2-a8a4-7257-8000-f987c11a4e80",
        "type": "department",
        "name": "Sales & Marketing : Marketing : 501 Marketing"
      },
      "gl_code": {
        "id": "0687fba6-41b3-7067-8000-4329a69c2dc4",
        "type": "gl_code",
        "name": "7510 Paid Media"
      },
      "matched_purchase_order_line_item": {
        "id": "0d3c861f-3162-8900-8a40-01956827f833",
        "type": "line_item",
        "line_type": 1,
        "description": "catherine test",
        "quantity": "1",
        "total": "2100000",
        "rate": "2100000.0",
        "secondary_line_type": null,
        "line_number": 1,
        "currency": "USD"
      },
      "amortization_schedule": {
        "start_date": null,
        "end_date": null,
        "name": "General Prepaid"
      },
      "attributes": [
        {
          "id": "0d3e411a-dfd8-8600-8dc0-0195696ecd2c",
          "config_id": "068855eb-ac96-737e-8000-17ead86fdf14",
          "name": "Location",
          "data": "AMER",
          "integration_data": null
        },
        {
          "id": "0d3e4078-c6ab-8100-8dc0-019569fe4347",
          "config_id": "068855eb-ad03-7fa9-8000-0d37aadb1cf1",
          "name": "Total price",
          "data": "1000000",
          "integration_data": null
        },
        {
          "id": "0d3e4078-6883-8d80-8dc0-01956b4f1f71",
          "config_id": "068855eb-b634-7855-8000-cefa27eeadec",
          "name": "Currency",
          "data": "USD",
          "integration_data": null
        },
        {
          "id": "0d3e4078-689c-8300-8dc0-01956ad5d72b",
          "config_id": "068855eb-b655-7b40-8000-c7f6a7e4a430",
          "name": "Department",
          "data": {
            "id": "0687fbf2-a8a4-7257-8000-f987c11a4e80",
            "type": "department",
            "name": "Sales & Marketing : Marketing : 501 Marketing",
            "display_name": "501 Marketing"
          },
          "integration_data": null
        },
        {
          "id": "0d3e4078-c692-8500-8dc0-01956bbfa00d",
          "config_id": "068855eb-d0f3-727f-8000-de66040014cc",
          "name": "Line description",
          "data": "catherine test",
          "integration_data": null
        },
        {
          "id": "0d3e4078-c6bc-8400-8dc0-01956bb1ac47",
          "config_id": "068855eb-d103-7fda-8000-73e5a34c67cf",
          "name": "Line type",
          "data": 1,
          "integration_data": null
        },
        {
          "id": "0d3e40d6-84d2-8500-8dc0-01956806ac2f",
          "config_id": "068855eb-d111-736f-8000-22cfe6f793a1",
          "name": "Secondary line type",
          "data": null,
          "integration_data": null
        },
        {
          "id": "0d3e4078-c6db-8500-8dc0-01956912f14d",
          "config_id": "068855eb-d125-7689-8000-680ebaaf0ac2",
          "name": "Unit price",
          "data": "1000000",
          "integration_data": null
        },
        {
          "id": "0d3e40d6-8533-8f00-8dc0-01956a30a40a",
          "config_id": "068855eb-d12f-7a05-8000-752a92541fc1",
          "name": "Total tax amount",
          "data": null,
          "integration_data": null
        },
        {
          "id": "0d3e40d6-8525-8600-8dc0-019568d3f2c7",
          "config_id": "068855eb-d13d-77a3-8000-4a379c0c68eb",
          "name": "Standard tax amount",
          "data": null,
          "integration_data": null
        },
        {
          "id": "0d3e40d6-8541-8a80-8dc0-01956beec726",
          "config_id": "068855eb-ddc2-78c2-8000-4242baf184a6",
          "name": "Withholding tax amount",
          "data": null,
          "integration_data": null
        },
        {
          "id": "0d3e4090-9f4f-8900-8dc0-0195692d7dad",
          "config_id": "068855ec-0175-7259-8000-c5520f4f424f",
          "name": "Matched PO line",
          "data": "0d3c861f-3162-8900-8a40-01956827f833",
          "integration_data": null
        },
        {
          "id": "0d3e40d6-84f2-8880-8dc0-01956b5e923e",
          "config_id": "068855ec-0b1d-7282-8000-081fbeb19b2b",
          "name": "Amortization schedule",
          "data": "General Prepaid",
          "integration_data": null
        },
        {
          "id": "0d3e41d3-941b-8e80-8dc0-0195698e4084",
          "config_id": "0d091d71-8aee-8900-8de0-019568f7817c",
          "name": "Project Code",
          "data": "0934_Procurement-Translations-Special Projects",
          "integration_data": {
            "id": "0d090dd0-d43c-8b80-8960-01956b891d9f",
            "type": "lookup_option",
            "key": "2433",
            "name": "0934_Procurement-Translations-Special Projects"
          }
        },
        {
          "id": "0d3e41e6-59d1-8b00-8dc0-01956a22489f",
          "config_id": "0d091d8c-a0c3-8980-8de0-01956993b9a8",
          "name": "Marketing Campaign",
          "data": "701Vp00000YVBbWIAX FY260923-SD-PartnerSalesMasterclass",
          "integration_data": {
            "id": "0d0918d1-7b81-8380-8960-019569c67242",
            "type": "lookup_option",
            "key": "9",
            "name": "701Vp00000YVBbWIAX FY260923-SD-PartnerSalesMasterclass"
          }
        },
        {
          "id": "0d3e421e-6a79-8000-8dc0-01956b0376bd",
          "config_id": "0d2fd350-6ce1-8700-8de0-01956a08c197",
          "name": "Amortization Start Date",
          "data": "2025-10-01",
          "integration_data": null
        },
        {
          "id": "0d3e4233-0e35-8980-8dc0-019569377fae",
          "config_id": "0d2fd374-fda5-8400-8de0-019569c22ebc",
          "name": "Amortization End Date",
          "data": "2026-09-01",
          "integration_data": null
        },
        {
          "id": "0d3e40d6-850a-8380-8dc0-01956a13541f",
          "config_id": "068855eb-b69c-703b-8000-2c58490246ff",
          "name": "Account",
          "data": "7510 Paid Media",
          "integration_data": null
        }
      ],
      "currency": "USD"
    }
  ],
  "payment_terms": {
    "id": "0687fbf0-f7c7-7be7-8000-cdae4cbaf2c3",
    "type": "payment_terms",
    "net_period_in_days": 30,
    "is_active": true,
    "name": "Net 30",
    "external_data": []
  },
  "subsidiary": {
    "id": "0687fba6-4b9d-7fad-8000-821c4eb1c055",
    "type": "subsidiary",
    "name": "Databricks, Inc."
  },
  "department": {
    "id": "0687fbf2-a8a4-72df-8000-59e8cf2524df",
    "type": "department",
    "name": "Sales & Marketing : Marketing : 502 AMER Regional",
    "external_ids": [
      {
        "id": "443",
        "source": "netsuite"
      }
    ]
  },
  "posting_period": {
    "id": "0cc3198f-be79-8480-a7c0-01956941b2a0",
    "type": "posting_period",
    "name": "Sep 2025"
  },
  "payment_method": null,
  "approved_at": 1759326930,
  "assignee": {
    "id": "0d1a92bd-a437-8c80-8100-019569ef936c",
    "type": "user",
    "last_name": "Kumar",
    "email": "neeraj.kumar@databricks.com",
    "first_name": "Neeraj"
  },
  "bill_creator": {
    "id": "0d1a92bd-a437-8c80-8100-019569ef936c",
    "type": "user",
    "last_name": "Kumar",
    "email": "neeraj.kumar@databricks.com",
    "first_name": "Neeraj"
  },
  "updated_at": 1759326930,
  "external_id": "18080416",
  "approvals": [
    {
      "id": "0d3e401f-45c2-8c00-8ea0-01956902e539",
      "type": "approval",
      "updated_at": 1759326890,
      "complete_time": 1759326890,
      "status": 3,
      "start_time": 1759326876,
      "request": {
        "id": "0d3e401a-8628-8e00-8720-01956a60480f",
        "type": "request",
        "status": "Approved",
        "request_number": null,
        "requester": {
          "id": "0d1a92bd-a437-8c80-8100-019569ef936c",
          "type": "user",
          "last_name": "Kumar",
          "email": "neeraj.kumar@databricks.com",
          "first_name": "Neeraj"
        },
        "name": null
      },
      "assignee": {
        "id": "0d1a92bd-a437-8c80-8100-019569ef936c",
        "type": "user",
        "last_name": "Kumar",
        "email": "neeraj.kumar@databricks.com",
        "first_name": "Neeraj"
      },
      "name": "AP Senior Manager Approval ",
      "display_status": "Approved"
    },
    {
      "id": "0d3e4020-6222-8a00-8ea0-01956bce0c06",
      "type": "approval",
      "updated_at": 1759326471,
      "complete_time": null,
      "status": null,
      "start_time": null,
      "request": {
        "id": "0d3e401a-8628-8e00-8720-01956a60480f",
        "type": "request",
        "status": "Approved",
        "request_number": null,
        "requester": {
          "id": "0d1a92bd-a437-8c80-8100-019569ef936c",
          "type": "user",
          "last_name": "Kumar",
          "email": "neeraj.kumar@databricks.com",
          "first_name": "Neeraj"
        },
        "name": null
      },
      "assignee": null,
      "name": "Milestone",
      "display_status": "Upcoming"
    },
    {
      "id": "0d3e4093-85ee-8d00-8ea0-019569362997",
      "type": "approval",
      "updated_at": 1759326914,
      "complete_time": 1759326914,
      "status": 3,
      "start_time": 1759326890,
      "request": {
        "id": "0d3e401a-8628-8e00-8720-01956a60480f",
        "type": "request",
        "status": "Approved",
        "request_number": null,
        "requester": {
          "id": "0d1a92bd-a437-8c80-8100-019569ef936c",
          "type": "user",
          "last_name": "Kumar",
          "email": "neeraj.kumar@databricks.com",
          "first_name": "Neeraj"
        },
        "name": null
      },
      "assignee": {
        "id": "0d1a91e9-e27f-8180-8100-019568289406",
        "type": "user",
        "last_name": "Francis",
        "email": "fenjo.francis@databricks.com",
        "first_name": "Fenjo"
      },
      "name": "PO Requester Approvers PO Based Bills",
      "display_status": "Approved"
    }
  ],
  "purchase_orders": [
    {
      "id": "0d3c861f-a3c2-8b00-93c0-019569c674e8",
      "type": "purchase_order",
      "po_number": "310",
      "external_id": null
    }
  ],
  "status": "PAID",
  "attributes": [
    {
      "id": "0d3e4112-9619-8080-8dc0-01956a06326b",
      "config_id": "068855eb-ac92-7a5c-8000-24b45c97dca5",
      "name": "Location",
      "data": "AMER",
      "integration_data": null
    },
    {
      "id": "0d3e4012-6b3a-8200-8dc0-01956811c685",
      "config_id": "068855eb-acf6-7e80-8000-3c715311485e",
      "name": "Total amount",
      "data": "1000000",
      "integration_data": null
    },
    {
      "id": "0d3e4012-6b67-8800-8dc0-01956bae1e2f",
      "config_id": "068855eb-b631-70d0-8000-c29c11d5f2a1",
      "name": "Currency",
      "data": "USD",
      "integration_data": null
    },
    {
      "id": "0d3e4012-6be8-8600-8dc0-01956b05cd62",
      "config_id": "068855eb-b673-72b0-8000-c839bbae959a",
      "name": "Subsidiary",
      "data": {
        "id": "0687fba6-4b9d-7fad-8000-821c4eb1c055",
        "type": "subsidiary",
        "name": "Databricks, Inc.",
        "display_name": ""
      },
      "integration_data": null
    },
    {
      "id": "0d3e4014-7090-8c00-8dc0-01956aaae867",
      "config_id": "068855eb-b6d6-735e-8000-1e51beb6272d",
      "name": "Payment terms",
      "data": "Net 30",
      "integration_data": null
    },
    {
      "id": "0d3e408f-4128-8800-8dc0-019569ffa537",
      "config_id": "068855eb-c4de-73f4-8000-1d7837e2d6a4",
      "name": "Requester",
      "data": null,
      "integration_data": null
    },
    {
      "id": "0d3e3ff8-0e7c-8480-8dc0-019569aa7130",
      "config_id": "068855eb-c6d1-7a1b-8000-e22bc4e43371",
      "name": "Vendor",
      "data": "0688d9cb-819b-7884-8000-e247c0c15cbe",
      "integration_data": null
    },
    {
      "id": "0d3e410e-aeef-8c80-8dc0-0195684d410a",
      "config_id": "068855eb-d0eb-7920-8000-f64705ece1df",
      "name": "Description",
      "data": "UAT Test Scrip E2E-001.1",
      "integration_data": null
    },
    {
      "id": "0d3e3ff8-0e64-8280-8dc0-019568b9a470",
      "config_id": "068855eb-f5a1-7813-8000-de187ddbdf4f",
      "name": "Invoice Upload Source",
      "data": 3,
      "integration_data": null
    },
    {
      "id": "0d3e3ff8-0e8c-8e00-8dc0-01956965e90b",
      "config_id": "068855eb-f61f-7389-8000-29c9ddfa17df",
      "name": "Attachments",
      "data": [
        "0d3e3ff7-27d3-8880-8880-01956add3302"
      ],
      "integration_data": null
    },
    {
      "id": "0d3e4012-6b85-8e80-8dc0-01956903ed8b",
      "config_id": "068855eb-f692-7043-8000-e9dba7173881",
      "name": "Invoice number",
      "data": "UHXKVMYK-0001",
      "integration_data": null
    },
    {
      "id": "0d3e4012-6ba3-8680-8dc0-0195688a25ab",
      "config_id": "068855eb-ff31-7f9d-8000-2618b3a75ecc",
      "name": "Invoice date",
      "data": "2025-09-30 00:00:00",
      "integration_data": null
    },
    {
      "id": "0d3e4012-6bbe-8a00-8dc0-01956a2539dc",
      "config_id": "068855eb-ff39-7672-8000-5c706855073c",
      "name": "Due date",
      "data": "2025-11-14 00:00:00",
      "integration_data": null
    },
    {
      "id": "0d3e4012-6c08-8400-8dc0-0195687ddd3f",
      "config_id": "068855eb-ff47-73ec-8000-fdbdc6cc3bab",
      "name": "Pre-tax total",
      "data": "1000000",
      "integration_data": null
    },
    {
      "id": "0d3e40c9-4817-8a00-8dc0-01956a45878d",
      "config_id": "068855eb-ff5c-764f-8000-c449a3276aa7",
      "name": "Standard tax amount",
      "data": "0",
      "integration_data": null
    },
    {
      "id": "0d3e408e-0285-8a80-8dc0-01956b799999",
      "config_id": "068855eb-acb8-78e9-8000-5294ee03fa79",
      "name": "Category",
      "data": "Marketing",
      "integration_data": null
    },
    {
      "id": "0d3e408e-029d-8f00-8dc0-01956824fb9c",
      "config_id": "068855eb-accc-7c6a-8000-19e399e3473b",
      "name": "Subcategory",
      "data": "(Demand Gen) Paid Media",
      "integration_data": null
    },
    {
      "id": "0d3e408e-02ae-8d80-8dc0-019569edb3c2",
      "config_id": "068855eb-b652-7634-8000-05d3f57d0ef6",
      "name": "Department",
      "data": {
        "id": "0687fbf2-a8a4-72df-8000-59e8cf2524df",
        "type": "department",
        "name": "Sales & Marketing : Marketing : 502 AMER Regional",
        "display_name": "502 AMER Regional"
      },
      "integration_data": null
    },
    {
      "id": "0d3e4335-0a35-8e00-8dc0-0195690ca8e4",
      "config_id": "068855eb-ff40-76b1-8000-4ea8faacfeb4",
      "name": "Posting date",
      "data": "2025-09-30 00:00:00",
      "integration_data": null
    }
  ],
  "payouts": [
    {
      "id": "0d47795f-ca3f-8680-9500-01956952de89",
      "external_id": "18081543"
    }
  ],
  "applied_vendor_credits": []
}

 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Unnikrishnan Nair Fivetranner

    Hi Himanshu,
    Thanks for adding the API response. As you are aware the zip docs are behind a login that we are unable to access - so our team will get in touch with you shortly so that we can understand the usecase in more detail as well as take further inputs. Rest assured, we are working to update the ZIP connector to support these fields.

    Regards,
    Unni