Create Many Customers
curl --request POST \
--url https://api.upwell.com/api/rest/bulk-customers \
--header 'Authorization: <api-key>' \
--header 'Content-Type: application/json' \
--data '
{
"inputs": [
{
"addresses": {
"data": [
{
"canonicalAddressId": "<string>",
"city": "<string>",
"companyId": "<string>",
"companyName": "<string>",
"customerId": "<string>",
"locationCodeId": "<string>",
"name": "<string>",
"phoneNumber": "<string>",
"stateOrProvince": "<string>",
"streetLine1": "<string>",
"streetLine2": "<string>",
"streetLine3": "<string>",
"zipOrPostalCode": "<string>"
}
]
},
"addressesLastUpdatedAt": "2023-11-07T05:31:56Z",
"billToCode": "<string>",
"billToCustomerId": "<string>",
"billToSource": "<string>",
"ccEmailAddresses": [
"<string>"
],
"collectorId": "<string>",
"contacts": {
"data": [
{
"customerId": "<string>",
"email": "<unknown>",
"phoneNumber": "<unknown>"
}
]
},
"contactsLastUpdatedAt": "2023-11-07T05:31:56Z",
"customerRule": {
"data": {
"autoSend": true,
"automationGoLiveDate": "2023-12-25",
"customFilenameConfig": "<unknown>",
"dueOption": 123,
"invoiceCreationEnabled": true,
"invoiceCreationMode": "<string>",
"invoiceOrganizationTemplateId": "<string>",
"listBillColumnTemplateId": "<string>",
"organizationEmailTemplatesId": "<string>",
"postDeliveryInvoiceBufferDays": 123,
"statementOrganizationEmailTemplatesId": "<string>"
}
},
"deletedAt": "<unknown>",
"emailAddress": "<string>",
"enabledAt": "2023-11-07T05:31:56Z",
"isActive": true,
"mergedIntoCustomerId": "<string>",
"metadata": "<unknown>",
"name": "<string>",
"paymentDiscountTerms": "<unknown>",
"payorAliases": "<unknown>",
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"tmsBalanceCents": "<unknown>",
"tmsCustomerType": "<string>",
"upwellDeliveryEnabled": true
}
]
}
'import requests
url = "https://api.upwell.com/api/rest/bulk-customers"
payload = { "inputs": [
{
"addresses": { "data": [
{
"canonicalAddressId": "<string>",
"city": "<string>",
"companyId": "<string>",
"companyName": "<string>",
"customerId": "<string>",
"locationCodeId": "<string>",
"name": "<string>",
"phoneNumber": "<string>",
"stateOrProvince": "<string>",
"streetLine1": "<string>",
"streetLine2": "<string>",
"streetLine3": "<string>",
"zipOrPostalCode": "<string>"
}
] },
"addressesLastUpdatedAt": "2023-11-07T05:31:56Z",
"billToCode": "<string>",
"billToCustomerId": "<string>",
"billToSource": "<string>",
"ccEmailAddresses": ["<string>"],
"collectorId": "<string>",
"contacts": { "data": [
{
"customerId": "<string>",
"email": "<unknown>",
"phoneNumber": "<unknown>"
}
] },
"contactsLastUpdatedAt": "2023-11-07T05:31:56Z",
"customerRule": { "data": {
"autoSend": True,
"automationGoLiveDate": "2023-12-25",
"customFilenameConfig": "<unknown>",
"dueOption": 123,
"invoiceCreationEnabled": True,
"invoiceCreationMode": "<string>",
"invoiceOrganizationTemplateId": "<string>",
"listBillColumnTemplateId": "<string>",
"organizationEmailTemplatesId": "<string>",
"postDeliveryInvoiceBufferDays": 123,
"statementOrganizationEmailTemplatesId": "<string>"
} },
"deletedAt": "<unknown>",
"emailAddress": "<string>",
"enabledAt": "2023-11-07T05:31:56Z",
"isActive": True,
"mergedIntoCustomerId": "<string>",
"metadata": "<unknown>",
"name": "<string>",
"paymentDiscountTerms": "<unknown>",
"payorAliases": "<unknown>",
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"tmsBalanceCents": "<unknown>",
"tmsCustomerType": "<string>",
"upwellDeliveryEnabled": True
}
] }
headers = {
"Authorization": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
inputs: [
{
addresses: {
data: [
{
canonicalAddressId: '<string>',
city: '<string>',
companyId: '<string>',
companyName: '<string>',
customerId: '<string>',
locationCodeId: '<string>',
name: '<string>',
phoneNumber: '<string>',
stateOrProvince: '<string>',
streetLine1: '<string>',
streetLine2: '<string>',
streetLine3: '<string>',
zipOrPostalCode: '<string>'
}
]
},
addressesLastUpdatedAt: '2023-11-07T05:31:56Z',
billToCode: '<string>',
billToCustomerId: '<string>',
billToSource: '<string>',
ccEmailAddresses: ['<string>'],
collectorId: '<string>',
contacts: {data: [{customerId: '<string>', email: '<unknown>', phoneNumber: '<unknown>'}]},
contactsLastUpdatedAt: '2023-11-07T05:31:56Z',
customerRule: {
data: {
autoSend: true,
automationGoLiveDate: '2023-12-25',
customFilenameConfig: '<unknown>',
dueOption: 123,
invoiceCreationEnabled: true,
invoiceCreationMode: '<string>',
invoiceOrganizationTemplateId: '<string>',
listBillColumnTemplateId: '<string>',
organizationEmailTemplatesId: '<string>',
postDeliveryInvoiceBufferDays: 123,
statementOrganizationEmailTemplatesId: '<string>'
}
},
deletedAt: '<unknown>',
emailAddress: '<string>',
enabledAt: '2023-11-07T05:31:56Z',
isActive: true,
mergedIntoCustomerId: '<string>',
metadata: '<unknown>',
name: '<string>',
paymentDiscountTerms: '<unknown>',
payorAliases: '<unknown>',
sourceSystem: '<string>',
sourceSystemId: '<string>',
tmsBalanceCents: '<unknown>',
tmsCustomerType: '<string>',
upwellDeliveryEnabled: true
}
]
})
};
fetch('https://api.upwell.com/api/rest/bulk-customers', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.upwell.com/api/rest/bulk-customers",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'inputs' => [
[
'addresses' => [
'data' => [
[
'canonicalAddressId' => '<string>',
'city' => '<string>',
'companyId' => '<string>',
'companyName' => '<string>',
'customerId' => '<string>',
'locationCodeId' => '<string>',
'name' => '<string>',
'phoneNumber' => '<string>',
'stateOrProvince' => '<string>',
'streetLine1' => '<string>',
'streetLine2' => '<string>',
'streetLine3' => '<string>',
'zipOrPostalCode' => '<string>'
]
]
],
'addressesLastUpdatedAt' => '2023-11-07T05:31:56Z',
'billToCode' => '<string>',
'billToCustomerId' => '<string>',
'billToSource' => '<string>',
'ccEmailAddresses' => [
'<string>'
],
'collectorId' => '<string>',
'contacts' => [
'data' => [
[
'customerId' => '<string>',
'email' => '<unknown>',
'phoneNumber' => '<unknown>'
]
]
],
'contactsLastUpdatedAt' => '2023-11-07T05:31:56Z',
'customerRule' => [
'data' => [
'autoSend' => true,
'automationGoLiveDate' => '2023-12-25',
'customFilenameConfig' => '<unknown>',
'dueOption' => 123,
'invoiceCreationEnabled' => true,
'invoiceCreationMode' => '<string>',
'invoiceOrganizationTemplateId' => '<string>',
'listBillColumnTemplateId' => '<string>',
'organizationEmailTemplatesId' => '<string>',
'postDeliveryInvoiceBufferDays' => 123,
'statementOrganizationEmailTemplatesId' => '<string>'
]
],
'deletedAt' => '<unknown>',
'emailAddress' => '<string>',
'enabledAt' => '2023-11-07T05:31:56Z',
'isActive' => true,
'mergedIntoCustomerId' => '<string>',
'metadata' => '<unknown>',
'name' => '<string>',
'paymentDiscountTerms' => '<unknown>',
'payorAliases' => '<unknown>',
'sourceSystem' => '<string>',
'sourceSystemId' => '<string>',
'tmsBalanceCents' => '<unknown>',
'tmsCustomerType' => '<string>',
'upwellDeliveryEnabled' => true
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: <api-key>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.upwell.com/api/rest/bulk-customers"
payload := strings.NewReader("{\n \"inputs\": [\n {\n \"addresses\": {\n \"data\": [\n {\n \"canonicalAddressId\": \"<string>\",\n \"city\": \"<string>\",\n \"companyId\": \"<string>\",\n \"companyName\": \"<string>\",\n \"customerId\": \"<string>\",\n \"locationCodeId\": \"<string>\",\n \"name\": \"<string>\",\n \"phoneNumber\": \"<string>\",\n \"stateOrProvince\": \"<string>\",\n \"streetLine1\": \"<string>\",\n \"streetLine2\": \"<string>\",\n \"streetLine3\": \"<string>\",\n \"zipOrPostalCode\": \"<string>\"\n }\n ]\n },\n \"addressesLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"billToCode\": \"<string>\",\n \"billToCustomerId\": \"<string>\",\n \"billToSource\": \"<string>\",\n \"ccEmailAddresses\": [\n \"<string>\"\n ],\n \"collectorId\": \"<string>\",\n \"contacts\": {\n \"data\": [\n {\n \"customerId\": \"<string>\",\n \"email\": \"<unknown>\",\n \"phoneNumber\": \"<unknown>\"\n }\n ]\n },\n \"contactsLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"customerRule\": {\n \"data\": {\n \"autoSend\": true,\n \"automationGoLiveDate\": \"2023-12-25\",\n \"customFilenameConfig\": \"<unknown>\",\n \"dueOption\": 123,\n \"invoiceCreationEnabled\": true,\n \"invoiceCreationMode\": \"<string>\",\n \"invoiceOrganizationTemplateId\": \"<string>\",\n \"listBillColumnTemplateId\": \"<string>\",\n \"organizationEmailTemplatesId\": \"<string>\",\n \"postDeliveryInvoiceBufferDays\": 123,\n \"statementOrganizationEmailTemplatesId\": \"<string>\"\n }\n },\n \"deletedAt\": \"<unknown>\",\n \"emailAddress\": \"<string>\",\n \"enabledAt\": \"2023-11-07T05:31:56Z\",\n \"isActive\": true,\n \"mergedIntoCustomerId\": \"<string>\",\n \"metadata\": \"<unknown>\",\n \"name\": \"<string>\",\n \"paymentDiscountTerms\": \"<unknown>\",\n \"payorAliases\": \"<unknown>\",\n \"sourceSystem\": \"<string>\",\n \"sourceSystemId\": \"<string>\",\n \"tmsBalanceCents\": \"<unknown>\",\n \"tmsCustomerType\": \"<string>\",\n \"upwellDeliveryEnabled\": true\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.upwell.com/api/rest/bulk-customers")
.header("Authorization", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"inputs\": [\n {\n \"addresses\": {\n \"data\": [\n {\n \"canonicalAddressId\": \"<string>\",\n \"city\": \"<string>\",\n \"companyId\": \"<string>\",\n \"companyName\": \"<string>\",\n \"customerId\": \"<string>\",\n \"locationCodeId\": \"<string>\",\n \"name\": \"<string>\",\n \"phoneNumber\": \"<string>\",\n \"stateOrProvince\": \"<string>\",\n \"streetLine1\": \"<string>\",\n \"streetLine2\": \"<string>\",\n \"streetLine3\": \"<string>\",\n \"zipOrPostalCode\": \"<string>\"\n }\n ]\n },\n \"addressesLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"billToCode\": \"<string>\",\n \"billToCustomerId\": \"<string>\",\n \"billToSource\": \"<string>\",\n \"ccEmailAddresses\": [\n \"<string>\"\n ],\n \"collectorId\": \"<string>\",\n \"contacts\": {\n \"data\": [\n {\n \"customerId\": \"<string>\",\n \"email\": \"<unknown>\",\n \"phoneNumber\": \"<unknown>\"\n }\n ]\n },\n \"contactsLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"customerRule\": {\n \"data\": {\n \"autoSend\": true,\n \"automationGoLiveDate\": \"2023-12-25\",\n \"customFilenameConfig\": \"<unknown>\",\n \"dueOption\": 123,\n \"invoiceCreationEnabled\": true,\n \"invoiceCreationMode\": \"<string>\",\n \"invoiceOrganizationTemplateId\": \"<string>\",\n \"listBillColumnTemplateId\": \"<string>\",\n \"organizationEmailTemplatesId\": \"<string>\",\n \"postDeliveryInvoiceBufferDays\": 123,\n \"statementOrganizationEmailTemplatesId\": \"<string>\"\n }\n },\n \"deletedAt\": \"<unknown>\",\n \"emailAddress\": \"<string>\",\n \"enabledAt\": \"2023-11-07T05:31:56Z\",\n \"isActive\": true,\n \"mergedIntoCustomerId\": \"<string>\",\n \"metadata\": \"<unknown>\",\n \"name\": \"<string>\",\n \"paymentDiscountTerms\": \"<unknown>\",\n \"payorAliases\": \"<unknown>\",\n \"sourceSystem\": \"<string>\",\n \"sourceSystemId\": \"<string>\",\n \"tmsBalanceCents\": \"<unknown>\",\n \"tmsCustomerType\": \"<string>\",\n \"upwellDeliveryEnabled\": true\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.upwell.com/api/rest/bulk-customers")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"inputs\": [\n {\n \"addresses\": {\n \"data\": [\n {\n \"canonicalAddressId\": \"<string>\",\n \"city\": \"<string>\",\n \"companyId\": \"<string>\",\n \"companyName\": \"<string>\",\n \"customerId\": \"<string>\",\n \"locationCodeId\": \"<string>\",\n \"name\": \"<string>\",\n \"phoneNumber\": \"<string>\",\n \"stateOrProvince\": \"<string>\",\n \"streetLine1\": \"<string>\",\n \"streetLine2\": \"<string>\",\n \"streetLine3\": \"<string>\",\n \"zipOrPostalCode\": \"<string>\"\n }\n ]\n },\n \"addressesLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"billToCode\": \"<string>\",\n \"billToCustomerId\": \"<string>\",\n \"billToSource\": \"<string>\",\n \"ccEmailAddresses\": [\n \"<string>\"\n ],\n \"collectorId\": \"<string>\",\n \"contacts\": {\n \"data\": [\n {\n \"customerId\": \"<string>\",\n \"email\": \"<unknown>\",\n \"phoneNumber\": \"<unknown>\"\n }\n ]\n },\n \"contactsLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"customerRule\": {\n \"data\": {\n \"autoSend\": true,\n \"automationGoLiveDate\": \"2023-12-25\",\n \"customFilenameConfig\": \"<unknown>\",\n \"dueOption\": 123,\n \"invoiceCreationEnabled\": true,\n \"invoiceCreationMode\": \"<string>\",\n \"invoiceOrganizationTemplateId\": \"<string>\",\n \"listBillColumnTemplateId\": \"<string>\",\n \"organizationEmailTemplatesId\": \"<string>\",\n \"postDeliveryInvoiceBufferDays\": 123,\n \"statementOrganizationEmailTemplatesId\": \"<string>\"\n }\n },\n \"deletedAt\": \"<unknown>\",\n \"emailAddress\": \"<string>\",\n \"enabledAt\": \"2023-11-07T05:31:56Z\",\n \"isActive\": true,\n \"mergedIntoCustomerId\": \"<string>\",\n \"metadata\": \"<unknown>\",\n \"name\": \"<string>\",\n \"paymentDiscountTerms\": \"<unknown>\",\n \"payorAliases\": \"<unknown>\",\n \"sourceSystem\": \"<string>\",\n \"sourceSystemId\": \"<string>\",\n \"tmsBalanceCents\": \"<unknown>\",\n \"tmsCustomerType\": \"<string>\",\n \"upwellDeliveryEnabled\": true\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"createCustomers": {
"returning": [
{
"addresses": [
{
"city": "<string>",
"id": "<string>",
"stateOrProvince": "<string>",
"streetLine1": "<string>",
"streetLine2": "<string>",
"zipOrPostalCode": "<string>"
}
],
"balance": "<unknown>",
"billToCustomerId": "<string>",
"ccEmailAddresses": [
"<string>"
],
"createdAt": "2023-11-07T05:31:56Z",
"customerRule": {
"dueOption": 123,
"id": "<string>"
},
"emailAddress": "<string>",
"id": "<string>",
"metadata": "<unknown>",
"name": "<string>",
"overdueBalance": "<unknown>",
"overdueInvoiceCount": 123,
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"updatedAt": "2023-11-07T05:31:56Z"
}
]
}
}{
"error": "Not-NULL violation. null value in column \"shipment_id\" of relation \"shipments\" violates not-null constraint",
"code": "constraint-violation"
}Customers
Create Many Customers
Create multiple customers at once
POST
/
api
/
rest
/
bulk-customers
Create Many Customers
curl --request POST \
--url https://api.upwell.com/api/rest/bulk-customers \
--header 'Authorization: <api-key>' \
--header 'Content-Type: application/json' \
--data '
{
"inputs": [
{
"addresses": {
"data": [
{
"canonicalAddressId": "<string>",
"city": "<string>",
"companyId": "<string>",
"companyName": "<string>",
"customerId": "<string>",
"locationCodeId": "<string>",
"name": "<string>",
"phoneNumber": "<string>",
"stateOrProvince": "<string>",
"streetLine1": "<string>",
"streetLine2": "<string>",
"streetLine3": "<string>",
"zipOrPostalCode": "<string>"
}
]
},
"addressesLastUpdatedAt": "2023-11-07T05:31:56Z",
"billToCode": "<string>",
"billToCustomerId": "<string>",
"billToSource": "<string>",
"ccEmailAddresses": [
"<string>"
],
"collectorId": "<string>",
"contacts": {
"data": [
{
"customerId": "<string>",
"email": "<unknown>",
"phoneNumber": "<unknown>"
}
]
},
"contactsLastUpdatedAt": "2023-11-07T05:31:56Z",
"customerRule": {
"data": {
"autoSend": true,
"automationGoLiveDate": "2023-12-25",
"customFilenameConfig": "<unknown>",
"dueOption": 123,
"invoiceCreationEnabled": true,
"invoiceCreationMode": "<string>",
"invoiceOrganizationTemplateId": "<string>",
"listBillColumnTemplateId": "<string>",
"organizationEmailTemplatesId": "<string>",
"postDeliveryInvoiceBufferDays": 123,
"statementOrganizationEmailTemplatesId": "<string>"
}
},
"deletedAt": "<unknown>",
"emailAddress": "<string>",
"enabledAt": "2023-11-07T05:31:56Z",
"isActive": true,
"mergedIntoCustomerId": "<string>",
"metadata": "<unknown>",
"name": "<string>",
"paymentDiscountTerms": "<unknown>",
"payorAliases": "<unknown>",
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"tmsBalanceCents": "<unknown>",
"tmsCustomerType": "<string>",
"upwellDeliveryEnabled": true
}
]
}
'import requests
url = "https://api.upwell.com/api/rest/bulk-customers"
payload = { "inputs": [
{
"addresses": { "data": [
{
"canonicalAddressId": "<string>",
"city": "<string>",
"companyId": "<string>",
"companyName": "<string>",
"customerId": "<string>",
"locationCodeId": "<string>",
"name": "<string>",
"phoneNumber": "<string>",
"stateOrProvince": "<string>",
"streetLine1": "<string>",
"streetLine2": "<string>",
"streetLine3": "<string>",
"zipOrPostalCode": "<string>"
}
] },
"addressesLastUpdatedAt": "2023-11-07T05:31:56Z",
"billToCode": "<string>",
"billToCustomerId": "<string>",
"billToSource": "<string>",
"ccEmailAddresses": ["<string>"],
"collectorId": "<string>",
"contacts": { "data": [
{
"customerId": "<string>",
"email": "<unknown>",
"phoneNumber": "<unknown>"
}
] },
"contactsLastUpdatedAt": "2023-11-07T05:31:56Z",
"customerRule": { "data": {
"autoSend": True,
"automationGoLiveDate": "2023-12-25",
"customFilenameConfig": "<unknown>",
"dueOption": 123,
"invoiceCreationEnabled": True,
"invoiceCreationMode": "<string>",
"invoiceOrganizationTemplateId": "<string>",
"listBillColumnTemplateId": "<string>",
"organizationEmailTemplatesId": "<string>",
"postDeliveryInvoiceBufferDays": 123,
"statementOrganizationEmailTemplatesId": "<string>"
} },
"deletedAt": "<unknown>",
"emailAddress": "<string>",
"enabledAt": "2023-11-07T05:31:56Z",
"isActive": True,
"mergedIntoCustomerId": "<string>",
"metadata": "<unknown>",
"name": "<string>",
"paymentDiscountTerms": "<unknown>",
"payorAliases": "<unknown>",
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"tmsBalanceCents": "<unknown>",
"tmsCustomerType": "<string>",
"upwellDeliveryEnabled": True
}
] }
headers = {
"Authorization": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
inputs: [
{
addresses: {
data: [
{
canonicalAddressId: '<string>',
city: '<string>',
companyId: '<string>',
companyName: '<string>',
customerId: '<string>',
locationCodeId: '<string>',
name: '<string>',
phoneNumber: '<string>',
stateOrProvince: '<string>',
streetLine1: '<string>',
streetLine2: '<string>',
streetLine3: '<string>',
zipOrPostalCode: '<string>'
}
]
},
addressesLastUpdatedAt: '2023-11-07T05:31:56Z',
billToCode: '<string>',
billToCustomerId: '<string>',
billToSource: '<string>',
ccEmailAddresses: ['<string>'],
collectorId: '<string>',
contacts: {data: [{customerId: '<string>', email: '<unknown>', phoneNumber: '<unknown>'}]},
contactsLastUpdatedAt: '2023-11-07T05:31:56Z',
customerRule: {
data: {
autoSend: true,
automationGoLiveDate: '2023-12-25',
customFilenameConfig: '<unknown>',
dueOption: 123,
invoiceCreationEnabled: true,
invoiceCreationMode: '<string>',
invoiceOrganizationTemplateId: '<string>',
listBillColumnTemplateId: '<string>',
organizationEmailTemplatesId: '<string>',
postDeliveryInvoiceBufferDays: 123,
statementOrganizationEmailTemplatesId: '<string>'
}
},
deletedAt: '<unknown>',
emailAddress: '<string>',
enabledAt: '2023-11-07T05:31:56Z',
isActive: true,
mergedIntoCustomerId: '<string>',
metadata: '<unknown>',
name: '<string>',
paymentDiscountTerms: '<unknown>',
payorAliases: '<unknown>',
sourceSystem: '<string>',
sourceSystemId: '<string>',
tmsBalanceCents: '<unknown>',
tmsCustomerType: '<string>',
upwellDeliveryEnabled: true
}
]
})
};
fetch('https://api.upwell.com/api/rest/bulk-customers', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.upwell.com/api/rest/bulk-customers",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'inputs' => [
[
'addresses' => [
'data' => [
[
'canonicalAddressId' => '<string>',
'city' => '<string>',
'companyId' => '<string>',
'companyName' => '<string>',
'customerId' => '<string>',
'locationCodeId' => '<string>',
'name' => '<string>',
'phoneNumber' => '<string>',
'stateOrProvince' => '<string>',
'streetLine1' => '<string>',
'streetLine2' => '<string>',
'streetLine3' => '<string>',
'zipOrPostalCode' => '<string>'
]
]
],
'addressesLastUpdatedAt' => '2023-11-07T05:31:56Z',
'billToCode' => '<string>',
'billToCustomerId' => '<string>',
'billToSource' => '<string>',
'ccEmailAddresses' => [
'<string>'
],
'collectorId' => '<string>',
'contacts' => [
'data' => [
[
'customerId' => '<string>',
'email' => '<unknown>',
'phoneNumber' => '<unknown>'
]
]
],
'contactsLastUpdatedAt' => '2023-11-07T05:31:56Z',
'customerRule' => [
'data' => [
'autoSend' => true,
'automationGoLiveDate' => '2023-12-25',
'customFilenameConfig' => '<unknown>',
'dueOption' => 123,
'invoiceCreationEnabled' => true,
'invoiceCreationMode' => '<string>',
'invoiceOrganizationTemplateId' => '<string>',
'listBillColumnTemplateId' => '<string>',
'organizationEmailTemplatesId' => '<string>',
'postDeliveryInvoiceBufferDays' => 123,
'statementOrganizationEmailTemplatesId' => '<string>'
]
],
'deletedAt' => '<unknown>',
'emailAddress' => '<string>',
'enabledAt' => '2023-11-07T05:31:56Z',
'isActive' => true,
'mergedIntoCustomerId' => '<string>',
'metadata' => '<unknown>',
'name' => '<string>',
'paymentDiscountTerms' => '<unknown>',
'payorAliases' => '<unknown>',
'sourceSystem' => '<string>',
'sourceSystemId' => '<string>',
'tmsBalanceCents' => '<unknown>',
'tmsCustomerType' => '<string>',
'upwellDeliveryEnabled' => true
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: <api-key>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.upwell.com/api/rest/bulk-customers"
payload := strings.NewReader("{\n \"inputs\": [\n {\n \"addresses\": {\n \"data\": [\n {\n \"canonicalAddressId\": \"<string>\",\n \"city\": \"<string>\",\n \"companyId\": \"<string>\",\n \"companyName\": \"<string>\",\n \"customerId\": \"<string>\",\n \"locationCodeId\": \"<string>\",\n \"name\": \"<string>\",\n \"phoneNumber\": \"<string>\",\n \"stateOrProvince\": \"<string>\",\n \"streetLine1\": \"<string>\",\n \"streetLine2\": \"<string>\",\n \"streetLine3\": \"<string>\",\n \"zipOrPostalCode\": \"<string>\"\n }\n ]\n },\n \"addressesLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"billToCode\": \"<string>\",\n \"billToCustomerId\": \"<string>\",\n \"billToSource\": \"<string>\",\n \"ccEmailAddresses\": [\n \"<string>\"\n ],\n \"collectorId\": \"<string>\",\n \"contacts\": {\n \"data\": [\n {\n \"customerId\": \"<string>\",\n \"email\": \"<unknown>\",\n \"phoneNumber\": \"<unknown>\"\n }\n ]\n },\n \"contactsLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"customerRule\": {\n \"data\": {\n \"autoSend\": true,\n \"automationGoLiveDate\": \"2023-12-25\",\n \"customFilenameConfig\": \"<unknown>\",\n \"dueOption\": 123,\n \"invoiceCreationEnabled\": true,\n \"invoiceCreationMode\": \"<string>\",\n \"invoiceOrganizationTemplateId\": \"<string>\",\n \"listBillColumnTemplateId\": \"<string>\",\n \"organizationEmailTemplatesId\": \"<string>\",\n \"postDeliveryInvoiceBufferDays\": 123,\n \"statementOrganizationEmailTemplatesId\": \"<string>\"\n }\n },\n \"deletedAt\": \"<unknown>\",\n \"emailAddress\": \"<string>\",\n \"enabledAt\": \"2023-11-07T05:31:56Z\",\n \"isActive\": true,\n \"mergedIntoCustomerId\": \"<string>\",\n \"metadata\": \"<unknown>\",\n \"name\": \"<string>\",\n \"paymentDiscountTerms\": \"<unknown>\",\n \"payorAliases\": \"<unknown>\",\n \"sourceSystem\": \"<string>\",\n \"sourceSystemId\": \"<string>\",\n \"tmsBalanceCents\": \"<unknown>\",\n \"tmsCustomerType\": \"<string>\",\n \"upwellDeliveryEnabled\": true\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.upwell.com/api/rest/bulk-customers")
.header("Authorization", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"inputs\": [\n {\n \"addresses\": {\n \"data\": [\n {\n \"canonicalAddressId\": \"<string>\",\n \"city\": \"<string>\",\n \"companyId\": \"<string>\",\n \"companyName\": \"<string>\",\n \"customerId\": \"<string>\",\n \"locationCodeId\": \"<string>\",\n \"name\": \"<string>\",\n \"phoneNumber\": \"<string>\",\n \"stateOrProvince\": \"<string>\",\n \"streetLine1\": \"<string>\",\n \"streetLine2\": \"<string>\",\n \"streetLine3\": \"<string>\",\n \"zipOrPostalCode\": \"<string>\"\n }\n ]\n },\n \"addressesLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"billToCode\": \"<string>\",\n \"billToCustomerId\": \"<string>\",\n \"billToSource\": \"<string>\",\n \"ccEmailAddresses\": [\n \"<string>\"\n ],\n \"collectorId\": \"<string>\",\n \"contacts\": {\n \"data\": [\n {\n \"customerId\": \"<string>\",\n \"email\": \"<unknown>\",\n \"phoneNumber\": \"<unknown>\"\n }\n ]\n },\n \"contactsLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"customerRule\": {\n \"data\": {\n \"autoSend\": true,\n \"automationGoLiveDate\": \"2023-12-25\",\n \"customFilenameConfig\": \"<unknown>\",\n \"dueOption\": 123,\n \"invoiceCreationEnabled\": true,\n \"invoiceCreationMode\": \"<string>\",\n \"invoiceOrganizationTemplateId\": \"<string>\",\n \"listBillColumnTemplateId\": \"<string>\",\n \"organizationEmailTemplatesId\": \"<string>\",\n \"postDeliveryInvoiceBufferDays\": 123,\n \"statementOrganizationEmailTemplatesId\": \"<string>\"\n }\n },\n \"deletedAt\": \"<unknown>\",\n \"emailAddress\": \"<string>\",\n \"enabledAt\": \"2023-11-07T05:31:56Z\",\n \"isActive\": true,\n \"mergedIntoCustomerId\": \"<string>\",\n \"metadata\": \"<unknown>\",\n \"name\": \"<string>\",\n \"paymentDiscountTerms\": \"<unknown>\",\n \"payorAliases\": \"<unknown>\",\n \"sourceSystem\": \"<string>\",\n \"sourceSystemId\": \"<string>\",\n \"tmsBalanceCents\": \"<unknown>\",\n \"tmsCustomerType\": \"<string>\",\n \"upwellDeliveryEnabled\": true\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.upwell.com/api/rest/bulk-customers")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"inputs\": [\n {\n \"addresses\": {\n \"data\": [\n {\n \"canonicalAddressId\": \"<string>\",\n \"city\": \"<string>\",\n \"companyId\": \"<string>\",\n \"companyName\": \"<string>\",\n \"customerId\": \"<string>\",\n \"locationCodeId\": \"<string>\",\n \"name\": \"<string>\",\n \"phoneNumber\": \"<string>\",\n \"stateOrProvince\": \"<string>\",\n \"streetLine1\": \"<string>\",\n \"streetLine2\": \"<string>\",\n \"streetLine3\": \"<string>\",\n \"zipOrPostalCode\": \"<string>\"\n }\n ]\n },\n \"addressesLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"billToCode\": \"<string>\",\n \"billToCustomerId\": \"<string>\",\n \"billToSource\": \"<string>\",\n \"ccEmailAddresses\": [\n \"<string>\"\n ],\n \"collectorId\": \"<string>\",\n \"contacts\": {\n \"data\": [\n {\n \"customerId\": \"<string>\",\n \"email\": \"<unknown>\",\n \"phoneNumber\": \"<unknown>\"\n }\n ]\n },\n \"contactsLastUpdatedAt\": \"2023-11-07T05:31:56Z\",\n \"customerRule\": {\n \"data\": {\n \"autoSend\": true,\n \"automationGoLiveDate\": \"2023-12-25\",\n \"customFilenameConfig\": \"<unknown>\",\n \"dueOption\": 123,\n \"invoiceCreationEnabled\": true,\n \"invoiceCreationMode\": \"<string>\",\n \"invoiceOrganizationTemplateId\": \"<string>\",\n \"listBillColumnTemplateId\": \"<string>\",\n \"organizationEmailTemplatesId\": \"<string>\",\n \"postDeliveryInvoiceBufferDays\": 123,\n \"statementOrganizationEmailTemplatesId\": \"<string>\"\n }\n },\n \"deletedAt\": \"<unknown>\",\n \"emailAddress\": \"<string>\",\n \"enabledAt\": \"2023-11-07T05:31:56Z\",\n \"isActive\": true,\n \"mergedIntoCustomerId\": \"<string>\",\n \"metadata\": \"<unknown>\",\n \"name\": \"<string>\",\n \"paymentDiscountTerms\": \"<unknown>\",\n \"payorAliases\": \"<unknown>\",\n \"sourceSystem\": \"<string>\",\n \"sourceSystemId\": \"<string>\",\n \"tmsBalanceCents\": \"<unknown>\",\n \"tmsCustomerType\": \"<string>\",\n \"upwellDeliveryEnabled\": true\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"createCustomers": {
"returning": [
{
"addresses": [
{
"city": "<string>",
"id": "<string>",
"stateOrProvince": "<string>",
"streetLine1": "<string>",
"streetLine2": "<string>",
"zipOrPostalCode": "<string>"
}
],
"balance": "<unknown>",
"billToCustomerId": "<string>",
"ccEmailAddresses": [
"<string>"
],
"createdAt": "2023-11-07T05:31:56Z",
"customerRule": {
"dueOption": 123,
"id": "<string>"
},
"emailAddress": "<string>",
"id": "<string>",
"metadata": "<unknown>",
"name": "<string>",
"overdueBalance": "<unknown>",
"overdueInvoiceCount": 123,
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"updatedAt": "2023-11-07T05:31:56Z"
}
]
}
}{
"error": "Not-NULL violation. null value in column \"shipment_id\" of relation \"shipments\" violates not-null constraint",
"code": "constraint-violation"
}Bulk bodies use
{ "inputs": [ ... ] } (plural) — not the singular input wrapper. See Money & payloads.Authorizations
Your API key, sent in the Authorization header: Authorization: YOUR_API_KEY. A Bearer prefix is also accepted (Authorization: Bearer YOUR_API_KEY). Keys are created in the Upwell dashboard (Account → API keys) and are scoped to one organization.
Body
application/json
Query parameters can also be provided in the request body as a JSON object
Show child attributes
Show child attributes
Response
Responses for POST /api/rest/bulk-customers
response of any mutation on the table "customers"
Show child attributes
Show child attributes
⌘I