Connector Improvement: Connector Improvement: ZIP Connector enhancement
AnsweredWe 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": []
}
-
Official comment
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
Please sign in to leave a comment.
Comments
1 comment