Import configuration
Setup
Create webhook as described in Integration Setup and use the right link from the table below (according the Rossum environment of configured account)
Import endpoints
| Environment | Webhook URL |
|---|---|
| EU1 Ireland | https://elis.rossum.ai/svc/scheduled-imports/api/coupa/v1/import |
| EU2 Frankfurt | https://shared-eu2.rossum.app/svc/scheduled-imports/api/coupa/v1/import |
| US east coast | — |
| Japan Tokyo | — |
Configuration examples
Currencies
See Currencies API (/currencies)
{
"credentials": {
"client_id": "…",
"base_api_url": "…",
"client_scope": "core.common.read"
},
"import_config": {
"query": {
"fields": ["id", "code", "decimals"]
},
"method": "replace",
"endpoint": "api/currencies",
"dataset_name": "dataset_currencies",
"records_per_request": 50
}
}
Invoices
tip
Query attributes necessary for differential update are highlighted.
{
"credentials": {
"client_id": "…",
"base_api_url": "….coupacloud.com/",
"client_scope": "core.invoice.read"
},
"import_config": {
"query": {
"order_by": "created_at",
"updated-at[gt_or_eq]": "${last_modified_date}"
},
"method": "update",
"id_keys": ["id"],
"endpoint": "api/invoices",
"dataset_name": "COUPA_DEV_invoices_v1",
"records_per_request": 50
}
}
Lookup values
See: Lookup Values API (/lookup_values)
tip
Query attributes necessary for differential update are highlighted.
{
"credentials": {
"client_id": "…",
"base_api_url": "….coupacloud.com/",
"client_scope": "core.common.read"
},
"import_config": {
"query": {
"fields": [
"id",
"name",
"external-ref-num",
"external-ref-code",
"active",
{
"parent": [
"id",
"name",
"active",
{
"custom_fields": {}
},
{
"parent": [
"id",
"name",
"active",
{
"custom_fields": {}
}
]
}
]
},
{
"lookup": ["id", "name", "active"]
},
{
"custom_fields": {}
}
],
"order_by": "created_at",
"updated-at[gt_or_eq]": "${last_modified_date}"
},
"method": "update",
"id_keys": ["id"],
"endpoint": "api/lookup_values",
"dataset_name": "lookup_values",
"records_per_request": 50
}
}
Payment Terms
See: Payment Terms API (/payment_terms)
tip
Query attributes necessary for differential update are highlighted.
{
"credentials": {
"client_id": "…",
"base_api_url": "…",
"client_scope": "core.common.read"
},
"import_config": {
"query": {
"order_by": "created_at",
"updated-at[gt_or_eq]": "${last_modified_date}"
},
"method": "update",
"id_keys": ["id"],
"endpoint": "api/payment_terms",
"dataset_name": "COUPA_DEV_payment_terms_v1",
"records_per_request": 50
}
}
Purchase orders
{
"credentials": {
"client_id": "…",
"base_api_url": "…",
"client_scope": "core.purchase_order.read"
},
"import_config": {
"query": {
"dir": "desc",
"fields": [
"id",
"created_at",
"updated_at",
"po_number",
"status",
"version",
"payment_method",
"ship_to_attention",
{
"ship_to_address": [
"id",
"created_at",
"updated_at",
"name",
"location_code",
"street1",
"street2",
"street3",
"street4",
"city",
"state",
"postal_code",
"attention",
"active",
"business_group_name",
"vat_number",
"local_tax_number",
"type",
{
"country": ["id", "code", "name"]
}
]
},
{
"supplier": ["id", "name", "display_name", "number"]
},
{
"order_lines": [
"id",
"created_at",
"updated_at",
"accounting_total",
{
"accounting_total_currency": ["id", "code", "decimals"]
},
{
"custom_fields": ["start_date", "end_date", "payment_method"]
},
"description",
"line_num",
"order_header_id",
"order_header_number",
"price",
"quantity",
"source_part_num",
"status",
"sub_line_num",
"total",
"type",
"version",
"supplier_order_number",
{
"account": [
"id",
"created_at",
"updated_at",
"name",
"code",
"active",
"account_type_id",
"segment_1",
"segment_2",
"segment_3",
"segment_4",
"segment_5",
"segment_6",
"segment_7",
"segment_8",
"segment_9",
"segment_10",
"segment_11",
"segment_12",
"segment_13",
"segment_14",
"segment_15",
"segment_16",
"segment_17",
"segment_18",
"segment_19",
"segment_20"
]
},
{
"currency": ["id", "code", "decimals"]
},
{
"supplier": ["id", "name", "display_name", "number"]
},
{
"uom": [
"id",
"created_at",
"updated_at",
"code",
"name",
"allowable_precision",
"active"
]
}
]
}
],
"order_by": "created_at",
"updated-at[gt_or_eq]": "${last_modified_date}"
},
"method": "update",
"id_keys": ["id"],
"endpoint": "api/purchase_orders",
"dataset_name": "purchase_orders",
"records_per_request": 50
}
}
Purchase order - Line items
{
"credentials": {
"client_id": "…",
"base_api_url": "…",
"client_scope": "core.purchase_order.read"
},
"import_config": {
"query": {
"dir": "desc",
"fields": [
"id",
"created_at",
"updated_at",
"accounting_total",
{
"accounting_total_currency": ["id", "code", "decimals"]
},
{
"custom_fields": ["start_date", "end_date", "payment_method"]
},
"description",
"line_num",
"order_header_id",
"order_header_number",
"price",
"quantity",
"source_part_num",
"status",
"sub_line_num",
"total",
"type",
"version",
"supplier_order_number",
{
"account": [
"id",
"created_at",
"updated_at",
"name",
"code",
"active",
"account_type_id",
"segment_1",
"segment_2",
"segment_3",
"segment_4",
"segment_5",
"segment_6",
"segment_7",
"segment_8",
"segment_9",
"segment_10",
"segment_11",
"segment_12",
"segment_13",
"segment_14",
"segment_15",
"segment_16",
"segment_17",
"segment_18",
"segment_19",
"segment_20"
]
},
{
"currency": ["id", "code", "decimals"]
},
{
"supplier": ["id", "name", "display_name", "number"]
},
{
"uom": ["id", "created_at", "updated_at", "code", "name", "allowable_precision", "active"]
}
],
"order_by": "created_at",
"updated-at[gt_or_eq]": "${last_modified_date}"
},
"method": "update",
"id_keys": ["id"],
"endpoint": "api/purchase_order_lines",
"dataset_name": "purchase_order_lines",
"records_per_request": 50
}
}
Suppliers
{
"credentials": {
"client_id": "…",
"base_api_url": "…",
"client_scope": "core.accounting.read, core.common.read, core.invoice.create, core.invoice.read, core.invoice.write, core.purchase_order.read, core.supplier.read"
},
"import_config": {
"query": {
"fields": [
"id",
"created_at",
"updated_at",
"name",
"display_name",
"number",
"status",
"po_email",
"account_number",
"tax_id",
{
"primary_contact": [
"id",
"created_at",
"updated_at",
"email",
"name_prefix",
"name_suffix",
"name_additional",
"name_given",
"name_family",
"name_fullname",
"notes",
"active",
"purposes"
]
},
{
"primary_address": [
"id",
"created_at",
"updated_at",
"name",
"location_code",
"street1",
"street2",
"street3",
"street4",
"city",
"state",
"postal_code",
"attention",
"active",
"business_group_name",
"vat_number",
"local_tax_number",
"type",
{
"country": ["id", "code", "name"]
},
{
"vat_country": ["id", "code", "name"]
}
]
},
{
"remit_to_addresses": [
"id",
"created_at",
"updated_at",
"remit_to_code",
"name",
"street1",
"street2",
"street3",
"street4",
"city",
"state",
"postal_code",
"active",
"vat_number",
"local_tax_number",
"external_src_ref",
"external_src_name",
{
"country": ["id", "code", "name"]
}
]
}
]
},
"method": "replace",
"endpoint": "api/suppliers",
"dataset_name": "dataset_suppliers",
"records_per_request": 50
}
}
Supplier information
{
"credentials": {
"client_id": "…",
"base_api_url": "…",
"client_scope": "core.supplier.read"
},
"import_config": {
"query": {
"fields": [
"id",
"created_at",
"updated_at",
"supplier_id",
"name",
"display_name",
"supplier_number",
"status",
"industry",
"inco_terms",
"minority_indicator",
"minority_type_id",
"tax_region",
"tax_classification",
"federal_tax_num",
"social_security_number",
"duns_number",
"tax_exempt_other_explanation",
"income_type",
"fed_reportable",
"intl_tax_num",
"intl_tax_classification",
"intl_other_explanation",
"backend_system_invoicing",
"backend_system_catalog",
"supplier_region",
"payment_terms_id",
"payment_term_id",
"govt_agency_interaction_indicator",
"govt_agency_interaction",
"organization_type",
"policy_for_bribery_corruption_indicator",
"policy_for_bribery_corruption",
"govt_allegation_fraud_bribery_indicator",
"govt_allegation_fraud_bribery",
"third_party_interaction_indicator",
"third_party_interaction",
"goods_services_provided",
"pay_group",
"invoice_amount_limit",
"hold_payment_indicator",
"hold_payment",
"separate_remit_to",
"comment_source",
"comment",
"last_exported_at",
"logo_file_name",
"logo_content_type",
"logo_file_size",
"logo_updated_at",
"website",
"allow_cxml_invoicing",
"hold_invoices_for_ap_review",
"send_invoices_to_approvals",
"allow_inv_no_backing_doc_from_connect",
"allow_inv_unbacked_lines_from_connect",
"commodity_id",
"invoice_matching_level",
"shipping_term_id",
"tax_code_id",
"savings_pct",
"allow_inv_from_connect",
"allow_inv_choose_billing_account",
"invoice_inbound_emails",
"default_invoice_email",
"inbound_invoice_domain",
"duplicate_exists",
"estimated_spend_amount",
"currency_id",
"user_id",
"one_time_supplier",
"scope_three_emissions",
"po_email",
"po_method",
"po_change_method",
"buyer_hold",
"cxml_url",
"cxml_domain",
"cxml_identity",
"cxml_supplier_domain",
"cxml_supplier_identity",
"cxml_secret",
"cxml_protocol",
"cxml_ssl_version",
"disable_cert_verify",
{
"custom_fields": [
"primary_subsidiary",
"subs_secondary",
"vendor_region",
"payment_file_format",
"company_registration_number",
"eligibility_1099",
"critical_vs_not_critical_vendor",
"permanent_account_number_pan",
"msmeudyam_registration_number",
"credit_card_vendor",
"credit_card",
"vendor_require_risk_questionnaire",
"risk_review",
"expedited_vendor",
"msme_registration_certificate",
"additional_currency",
"payment_remittance_email",
"wil_be_sued_for_po__backed_purchases"
]
},
{
"supplier_information_addresses": [
"intermediary_bank_name",
"bank_address",
"bank_city",
"bank_state_region",
"bank_postal_code",
"name_on_bank_account",
"bank_name",
"bank_account_number",
"bank_routing_number",
"wire_routing_number",
"international_bank_account_number",
"iban_number",
"sort_code",
"swift_code",
"bsb_number",
"bic",
"bank_code",
"ifsc",
"transit_number_and_institution_number",
"bic_routing_code",
"payment_method_item",
"active",
"csp_rta_id",
"email",
"virtual_card_email"
]
}
],
"updated-at[gt_or_eq]": "${last_modified_date}"
},
"method": "update",
"id_keys": ["id"],
"endpoint": "api/supplier_information",
"dataset_name": "supplier_information",
"records_per_request": 50
}
}
Tax Codes
{
"credentials": {
"client_id": "…",
"base_api_url": "…",
"client_scope": "core.common.read"
},
"import_config": {
"query": {
"updated-at[gt_or_eq]": "${last_modified_date}"
},
"method": "update",
"id_keys": ["id"],
"endpoint": "api/tax_codes",
"dataset_name": "tax_codes",
"records_per_request": 50
}
}
Units of measurement
{
"credentials": {
"client_id": "…",
"base_api_url": "….coupacloud.com/",
"client_scope": "core.common.read"
},
"import_config": {
"query": {
"fields": [
"id",
"name",
"code",
"allowable-precession",
"active",
"updated-at",
"created-at"
],
"order_by": "created_at",
"updated-at[gt_or_eq]": "${last_modified_date}"
},
"method": "update",
"id_keys": ["id"],
"endpoint": "api/uoms",
"dataset_name": "uoms",
"records_per_request": 50
}
}