curl --request POST \
--url https://api.upwell.com/api/rest/invoices/search \
--header 'Content-Type: application/json' \
--data '
{
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"limit": 10,
"offset": 0,
"orderBy": [],
"where": {}
}
'{
"invoices": [
{
"balance": 123,
"customer": {
"id": "<string>",
"name": "<string>"
},
"customerId": "<string>",
"dueDate": "2023-12-25",
"id": "<string>",
"issueDate": "2023-12-25",
"number": "<string>",
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"status": "APPROVED",
"totalAmount": 123,
"invoiceNumber": "<string>",
"createdAt": "2023-11-07T05:31:56Z",
"updatedAt": "2023-11-07T05:31:56Z"
}
]
}Search for invoices by source system and source system ID
curl --request POST \
--url https://api.upwell.com/api/rest/invoices/search \
--header 'Content-Type: application/json' \
--data '
{
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"limit": 10,
"offset": 0,
"orderBy": [],
"where": {}
}
'{
"invoices": [
{
"balance": 123,
"customer": {
"id": "<string>",
"name": "<string>"
},
"customerId": "<string>",
"dueDate": "2023-12-25",
"id": "<string>",
"issueDate": "2023-12-25",
"number": "<string>",
"sourceSystem": "<string>",
"sourceSystemId": "<string>",
"status": "APPROVED",
"totalAmount": 123,
"invoiceNumber": "<string>",
"createdAt": "2023-11-07T05:31:56Z",
"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
The source system identifier
The ID of the invoice in the source system
Boolean expression to filter rows from the table "invoices". All fields are combined with a logical 'AND'.
Show child attributes
InvoicesBoolExp (simplified)
EdiActiveEdiDocumentsBoolExp (simplified)
AuditLoggedActionsBoolExp (simplified)
AuditLoggedActionsAggregateBoolExp (simplified)
BooleanComparisonExp (simplified)
AuditLoggedActionsBoolExp (simplified)
AuditLoggedActionsAggregateBoolExp (simplified)
IntComparisonExp (simplified)
StringComparisonExp (simplified)
StringComparisonExp (simplified)
CassBarcodeMappingBoolExp (simplified)
CassBarcodeMappingAggregateBoolExp (simplified)
CassInvoiceStatusUpdatesBoolExp (simplified)
CassInvoiceStatusUpdatesAggregateBoolExp (simplified)
StringComparisonExp (simplified)
StringComparisonExp (simplified)
IntComparisonExp (simplified)
StringComparisonExp (simplified)
JsonbComparisonExp (simplified)
StringComparisonExp (simplified)
StringComparisonExp (simplified)
TimestamptzComparisonExp (simplified)
EmailMessagesBoolExp (simplified)
StringComparisonExp (simplified)
CurrencyCodeEnumComparisonExp (simplified)
CustomersBoolExp (simplified)
StringComparisonExp (simplified)
StringComparisonExp (simplified)
DebitsBoolExp (simplified)
DebitsAggregateBoolExp (simplified)
TimestampComparisonExp (simplified)
DateComparisonExp (simplified)
StringArrayComparisonExp (simplified)
JsonbComparisonExp (simplified)
DateComparisonExp (simplified)
EdiEdiDocumentsBoolExp (simplified)
EdiEdiDocumentsAggregateBoolExp (simplified)
EvalsBoolExp (simplified)
ExceptionsBoolExp (simplified)
ExceptionsAggregateBoolExp (simplified)
BooleanComparisonExp (simplified)
FileAssociationsBoolExp (simplified)
FileAssociationsAggregateBoolExp (simplified)
TimestampComparisonExp (simplified)
BooleanComparisonExp (simplified)
StringComparisonExp (simplified)
InvoiceActivityBoolExp (simplified)
InvoiceActivityAggregateBoolExp (simplified)
InvoiceCreationEventsBoolExp (simplified)
StringComparisonExp (simplified)
InvoiceLineItemsBoolExp (simplified)
InvoiceLineItemsAggregateBoolExp (simplified)
InvoiceShipmentsBoolExp (simplified)
InvoiceShipmentsAggregateBoolExp (simplified)
DateComparisonExp (simplified)
StringComparisonExp (simplified)
CassLatestInvoiceStatusBoolExp (simplified)
TimestamptzComparisonExp (simplified)
JsonbComparisonExp (simplified)
NotesBoolExp (simplified)
NotesAggregateBoolExp (simplified)
StringComparisonExp (simplified)
TimestamptzComparisonExp (simplified)
PaymentLineItemsBoolExp (simplified)
PaymentLineItemsAggregateBoolExp (simplified)
StringComparisonExp (simplified)
StringComparisonExp (simplified)
TimestampComparisonExp (simplified)
StringComparisonExp (simplified)
JsonbComparisonExp (simplified)
RemindersBoolExp (simplified)
RemindersAggregateBoolExp (simplified)
RemittanceLineItemsBoolExp (simplified)
DateComparisonExp (simplified)
TimestampComparisonExp (simplified)
StringComparisonExp (simplified)
DateComparisonExp (simplified)
StringComparisonExp (simplified)
StringComparisonExp (simplified)
JsonbComparisonExp (simplified)
StatementsBoolExp (simplified)
StringComparisonExp (simplified)
StatementsBoolExp (simplified)
StatementsAggregateBoolExp (simplified)
InvoiceStatusEnumComparisonExp (simplified)
TenantsBoolExp (simplified)
StringComparisonExp (simplified)
IntComparisonExp (simplified)
IntComparisonExp (simplified)
TimestamptzComparisonExp (simplified)
Responses for POST /api/rest/invoices/search
Show child attributes
A date string, such as 2024-02-03 (YYYY-MM-DD)
A date string, such as 2024-02-03 (YYYY-MM-DD)
APPROVED, CANCELLED, CREATED, DELIVERED, DISPUTED, OPEN, OVERDUE, PAID, PART_PAID, PORTAL_EXCEPTION, PORTAL_RESOLVED, PROCESSING, REFUNDED, SEND_ERROR, SENT, VIEWED, WRITE_OFF 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