curl --request POST \
--url https://api.upwell.com/api/rest/customers/search \
--header 'Content-Type: application/json' \
--data '
{
"limit": 10,
"offset": 0,
"orderBy": {},
"where": {}
}
'{
"customers": [
{
"addresses": [
{
"city": "<string>",
"country": "AD",
"id": "<string>",
"stateOrProvince": "<string>",
"streetLine1": "<string>",
"streetLine2": "<string>",
"type": "ADDRESS_BOOK",
"zipOrPostalCode": "<string>"
}
],
"balance": 123,
"billToCustomerId": "<string>",
"ccEmailAddresses": [
"<string>"
],
"createdAt": "2023-11-07T05:31:56Z",
"customerRule": {
"dueOption": 123,
"id": "<string>"
},
"emailAddress": "<string>",
"id": "<string>",
"metadata": "<unknown>",
"name": "<string>",
"overdueBalance": 123,
"overdueInvoiceCount": 123,
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"updatedAt": "2023-11-07T05:31:56Z"
}
]
}Search for customers based on specified criteria
curl --request POST \
--url https://api.upwell.com/api/rest/customers/search \
--header 'Content-Type: application/json' \
--data '
{
"limit": 10,
"offset": 0,
"orderBy": {},
"where": {}
}
'{
"customers": [
{
"addresses": [
{
"city": "<string>",
"country": "AD",
"id": "<string>",
"stateOrProvince": "<string>",
"streetLine1": "<string>",
"streetLine2": "<string>",
"type": "ADDRESS_BOOK",
"zipOrPostalCode": "<string>"
}
],
"balance": 123,
"billToCustomerId": "<string>",
"ccEmailAddresses": [
"<string>"
],
"createdAt": "2023-11-07T05:31:56Z",
"customerRule": {
"dueOption": 123,
"id": "<string>"
},
"emailAddress": "<string>",
"id": "<string>",
"metadata": "<unknown>",
"name": "<string>",
"overdueBalance": 123,
"overdueInvoiceCount": 123,
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"updatedAt": "2023-11-07T05:31:56Z"
}
]
}Your API key will be used for authentication of the request. Authorization: YOUR_API_KEY
Query parameters can also be provided in the request body as a JSON object
Boolean expression to filter rows from the table "customers". All fields are combined with a logical 'AND'.
Show child attributes
CustomersBoolExp (simplified)
AddressesBoolExp (simplified)
AddressesAggregateBoolExp (simplified)
TimestamptzComparisonExp (simplified)
AuditLoggedActionsBoolExp (simplified)
AuditLoggedActionsAggregateBoolExp (simplified)
IntComparisonExp (simplified)
BasisTheoryPreferredPaymentMethodsBoolExp (simplified)
CustomersBoolExp (simplified)
StringComparisonExp (simplified)
CustomerIntegrationsMappingBoolExp (simplified)
CustomerIntegrationsMappingAggregateBoolExp (simplified)
StringArrayComparisonExp (simplified)
UsersBoolExp (simplified)
UuidComparisonExp (simplified)
ContactsBoolExp (simplified)
ContactsAggregateBoolExp (simplified)
TimestamptzComparisonExp (simplified)
TimestamptzComparisonExp (simplified)
JsonbComparisonExp (simplified)
CustomerEmailSettingsBoolExp (simplified)
CustomerEmailSettingsAggregateBoolExp (simplified)
CustomerIntegrationsMappingBoolExp (simplified)
CustomerIntegrationsMappingAggregateBoolExp (simplified)
CustomerIntegrationSettingsBoolExp (simplified)
CustomerIntegrationSettingsAggregateBoolExp (simplified)
CustomerRulesBoolExp (simplified)
TimestampComparisonExp (simplified)
DeliveryMethodsBoolExp (simplified)
DeliveryMethodsAggregateBoolExp (simplified)
StringComparisonExp (simplified)
StringComparisonExp (simplified)
InvoiceCreationEventsBoolExp (simplified)
InvoiceCreationEventsAggregateBoolExp (simplified)
InvoicesBoolExp (simplified)
InvoicesAggregateBoolExp (simplified)
JsonbComparisonExp (simplified)
StringComparisonExp (simplified)
StringComparisonExp (simplified)
IntComparisonExp (simplified)
IntComparisonExp (simplified)
PaymentLineItemsBoolExp (simplified)
PaymentLineItemsAggregateBoolExp (simplified)
ReminderSequencesBoolExp (simplified)
StringComparisonExp (simplified)
JsonbComparisonExp (simplified)
RemindersBoolExp (simplified)
RemindersAggregateBoolExp (simplified)
RemittanceLineItemsBoolExp (simplified)
RemittanceLineItemsAggregateBoolExp (simplified)
JsonbComparisonExp (simplified)
RemittancesBoolExp (simplified)
RemittancesAggregateBoolExp (simplified)
ShipmentsBoolExp (simplified)
ShipmentsAggregateBoolExp (simplified)
StringComparisonExp (simplified)
StringComparisonExp (simplified)
JsonbComparisonExp (simplified)
StatementCreationEventsBoolExp (simplified)
StatementCreationEventsAggregateBoolExp (simplified)
StatementRulesBoolExp (simplified)
StatementRulesAggregateBoolExp (simplified)
StatementsBoolExp (simplified)
StatementsAggregateBoolExp (simplified)
TenantsBoolExp (simplified)
StringComparisonExp (simplified)
TimestamptzComparisonExp (simplified)
Responses for POST /api/rest/customers/search
Show child attributes
Show child attributes
AD, AE, AF, AG, AL, AM, AO, AR, AT, AU, AZ, BA, BB, BD, BE, BF, BG, BH, BI, BJ, BN, BO, BR, BS, BT, BW, BY, BZ, CA, CD, CF, CG, CH, CI, CL, CM, CN, CO, CR, CU, CV, CY, CZ, DE, DJ, DK, DM, DO, DZ, EC, EE, EG, ER, ES, ET, FI, FJ, FM, FR, GA, GB, GD, GE, GH, GM, GN, GQ, GR, GT, GW, GY, HK, HN, HR, HT, HU, ID, IE, IL, IN, IQ, IR, IS, IT, JM, JO, JP, KE, KG, KH, KI, KM, KN, KP, KR, KW, KZ, LA, LB, LC, LI, LK, LR, LS, LT, LU, LV, LY, MA, MC, MD, ME, MG, MH, MK, ML, MM, MN, MO, MR, MT, MU, MV, MW, MX, MY, MZ, NA, NE, NG, NI, NL, NO, NP, NR, NZ, OM, PA, PE, PG, PH, PK, PL, PR, PS, PT, PW, PY, QA, RO, RS, RU, RW, SA, SB, SC, SD, SE, SG, SI, SK, SL, SM, SN, SO, SR, SS, ST, SV, SY, SZ, TD, TG, TH, TJ, TL, TM, TN, TO, TR, TT, TV, TW, TZ, UA, UG, US, UY, UZ, VA, VC, VE, VN, VU, WS, YE, ZA, ZM, ZW ADDRESS_BOOK, CARRIER, CARRIER_BILLING, COMPANY_ADDRESS, CONTACT, CUSTOMER_BILLING, DELIVERY_RECEIPT, LUMPER_RECEIPT, SHIPMENT_CONSIGNEE, SHIPMENT_PICKUP, STOP, SUPPORTING_DOC_PARTY A timestamp with timezone in ISO 8601 format, such as 2024-12-16T21:57:14.525733+00:00
A timestamp with timezone in ISO 8601 format, such as 2024-12-16T21:57:14.525733+00:00