Introduction
Datasources and destinations
- Find all the data sources available at www.catchr.io/connectors
- Find all the destinations available at www.catchr.io/destinations
Day of the month Day of the year |
| ||||||
Day of the week Week of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Month of the year Month of the year |
| ||||||
Month and day Month and day |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Week of the year (start Sunday) Week of the year |
| ||||||
Year Year such as 2017. |
| ||||||
Year month Year and month. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year week Year and week. |
| ||||||
Account Number User-defined account number for the contact. Example: ACC-100 |
| ||||||
Accounts Payable Outstanding Outstanding payable balance for the contact. Example: 231.60 |
| ||||||
Accounts Payable Overdue Overdue payable balance for the contact. Example: 360.00 |
| ||||||
Accounts Receivable Outstanding Outstanding receivable balance for the contact. Example: 760.00 |
| ||||||
Accounts Receivable Overdue Overdue receivable balance for the contact. Example: 920.00 |
| ||||||
Bank Account Details Bank account details stored on the contact. Example: 12-1234-1234567-00 |
| ||||||
Contact Number External contact code used in Xero. Example: CONTACT-100 |
| ||||||
Default Phone Default phone number for the contact. Example: 847-1294 |
| ||||||
Email Address Primary email address for the contact. Example: kat.warren@clampett.com |
| ||||||
First Name First name for the contact. Example: Katherine |
| ||||||
Has Attachments Whether the contact has attachments in Xero. Example: false |
| ||||||
Contact ID Unique Xero contact identifier. Example: 5cc8cf28-567e-4d43-b287-687cfcaec47c |
| ||||||
Is Customer Whether the contact is marked as a customer. Example: true |
| ||||||
Is Supplier Whether the contact is marked as a supplier. Example: true |
| ||||||
Last Name Last name for the contact. Example: Warren |
| ||||||
Merged To Contact ID Destination contact when this contact was merged. Example: 3ec601ad-eddc-4ccb-a8ac-736e88293b1b |
| ||||||
Mobile Phone Mobile phone number for the contact. Example: 0211234567 |
| ||||||
Contact Name Full contact or company name. Example: Katherine Warren |
| ||||||
Postal City City from the postal address. Example: Palo Alto |
| ||||||
Postal Country Country from the postal address. Example: United States |
| ||||||
Postal Postal Code Postal code from the postal address. Example: 94020 |
| ||||||
Postal Region Region from the postal address. Example: CA |
| ||||||
Purchases Default Line Amount Type Default purchase line amount type for the contact. Example: INCLUSIVE |
| ||||||
Sales Default Line Amount Type Default sales line amount type for the contact. Example: INCLUSIVE |
| ||||||
Contact Status Current status of the contact. Example: ACTIVE |
| ||||||
Street City City from the street address. Example: London |
| ||||||
Street Country Country from the street address. Example: United Kingdom |
| ||||||
Street Postal Code Postal code from the street address. Example: SW1A 1AA |
| ||||||
Street Region Region from the street address. Example: Greater London |
| ||||||
Tax Number Tax number stored on the contact. Example: GB123456789 |
| ||||||
Updated Date UTC Timestamp when the contact was last updated. Example: 2017-08-22T18:49:04+00:00 |
| ||||||
Amount Credited Amount credited against the invoice. Example: 0.00 |
| ||||||
Amount Due Remaining amount due on the invoice. Example: 115.00 |
| ||||||
Amount Paid Amount already paid on the invoice. Example: 46.00 |
| ||||||
Contact Name Name of the related contact. Example: Barney Rubble-83203 |
| ||||||
Currency Code Currency code used by the invoice. Example: NZD |
| ||||||
Currency Rate Exchange rate used by the invoice. Example: 1.000000 |
| ||||||
Invoice Date Invoice issue date. Example: 2018-10-20T00:00:00+00:00 |
| ||||||
Due Date Invoice due date. Example: 2018-12-30T00:00:00+00:00 |
| ||||||
Fully Paid On Date Date when the invoice became fully paid. Example: 2018-11-29T00:00:00+00:00 |
| ||||||
Has Attachments Whether the invoice has attachments. Example: false |
| ||||||
Has Errors Whether Xero reported validation errors on the invoice. Example: false |
| ||||||
Invoice ID Unique Xero invoice identifier. Example: 046d8a6d-1ae1-4b4d-9340-5601bdf41b87 |
| ||||||
Invoice Number Human-readable invoice number. Example: INV-0002 |
| ||||||
Is Discounted Whether the invoice includes discounts. Example: false |
| ||||||
Line Amount Type Tax calculation mode for invoice lines. Example: Exclusive |
| ||||||
Line Item Count Number of line items returned on the invoice. Example: 3 |
| ||||||
Reference Reference stored on the invoice. Example: Red Fish, Blue Fish |
| ||||||
Repeating Invoice ID Identifier of the linked repeating invoice. Example: 428c0d75-909f-4b04-8403-a48dc27283b0 |
| ||||||
Sent To Contact Whether the invoice was sent to the contact. Example: true |
| ||||||
Invoice Status Current invoice status. Example: PAID |
| ||||||
Subtotal Subtotal before tax on the invoice. Example: 40.00 |
| ||||||
Total Total invoice amount including tax. Example: 46.00 |
| ||||||
Total Tax Total tax amount on the invoice. Example: 6.00 |
| ||||||
Invoice Type Invoice type returned by Xero. Example: ACCREC |
| ||||||
Updated Date UTC Timestamp when the invoice was last updated. Example: 2018-10-20T09:16:30+00:00 |
| ||||||
Account Code Account code linked to the invoice line. Example: 200 |
| ||||||
Account ID Account identifier linked to the invoice line. Example: 5690f1e8-1d02-4893-90c2-ee1a69eff942 |
| ||||||
Contact Name Name of the related contact. Example: Barney Rubble-83203 |
| ||||||
Description Description of the invoice line item. Example: Monthly subscription |
| ||||||
Discount Rate Discount rate applied to the line. Example: 10.0 |
| ||||||
Invoice Line ID Synthetic identifier for the invoice line row. Example: 046d8a6d-1ae1-4b4d-9340-5601bdf41b87_00000000-0000-0000-0000-000000000001 |
| ||||||
Invoice Date Date of the related invoice. Example: 2018-10-20T00:00:00+00:00 |
| ||||||
Invoice Number Invoice number for the related invoice. Example: INV-0002 |
| ||||||
Item Code Inventory or item code linked to the line. Example: SKU-001 |
| ||||||
Line Amount Total amount for the invoice line. Example: 40.00 |
| ||||||
Line Item ID Xero identifier for the invoice line item. Example: 00000000-0000-0000-0000-000000000000 |
| ||||||
Quantity Quantity on the invoice line. Example: 2.0 |
| ||||||
Tax Amount Tax amount on the invoice line. Example: 6.00 |
| ||||||
Tax Type Tax type applied on the invoice line. Example: OUTPUT |
| ||||||
Unit Amount Unit amount on the invoice line. Example: 20.00 |
| ||||||
Updated Date UTC Timestamp when the related invoice was last updated. Example: 2018-10-20T09:16:30+00:00 |
| ||||||
Base Currency Base currency configured on the organisation. Example: NZD |
| ||||||
Class Subscription class used by the organisation. Example: PREMIUM |
| ||||||
Country Code Country code of the organisation. Example: NZ |
| ||||||
Created Date UTC Timestamp when the organisation was created. Example: 2016-02-18T22:29:53+00:00 |
| ||||||
Default Purchases Tax Default purchase tax display mode. Example: Tax Exclusive |
| ||||||
Default Sales Tax Default sales tax display mode. Example: Tax Exclusive |
| ||||||
Edition Product edition used by the organisation. Example: BUSINESS |
| ||||||
End Of Year Lock Date Date after which end-of-year transactions are locked. Example: 2018-12-31T00:00:00+00:00 |
| ||||||
Financial Year End Day Day used to end the financial year. Example: 31 |
| ||||||
Financial Year End Month Month used to end the financial year. Example: 3 |
| ||||||
Organisation ID Unique Xero organisation identifier. Example: b2c885a9-4bb9-4a00-9b6e-6c2bf60b1a2b |
| ||||||
Is Demo Company Whether the connected organisation is a demo company. Example: false |
| ||||||
Legal Name Legal name shown on Xero reports. Example: Demo Company (NZ) |
| ||||||
Organisation Name Display name of the organisation in Xero. Example: Demo Company (NZ) |
| ||||||
Organisation Status Current organisation status. Example: ACTIVE |
| ||||||
Organisation Type Organisation entity type in Xero. Example: COMPANY |
| ||||||
Pays Tax Whether the organisation is registered for tax. Example: true |
| ||||||
Period Lock Date Date after which historical transactions are locked. Example: 2018-12-31T00:00:00+00:00 |
| ||||||
Sales Tax Basis Sales tax basis for the organisation. Example: PAYMENTS |
| ||||||
Sales Tax Period Sales tax reporting period. Example: TWOMONTHS |
| ||||||
Short Code Short code used by the organisation. Example: !mBdtL |
| ||||||
Tax Number Tax registration number on the organisation. Example: 071-138-054 |
| ||||||
Timezone Timezone configured for the organisation. Example: NEWZEALANDSTANDARDTIME |
| ||||||
Version Xero regional version for the organisation. Example: NZ |
| ||||||
Account Code Code of the account used for the payment. Example: 970 |
| ||||||
Account ID Identifier of the account used for the payment. Example: 5690f1e8-1d02-4893-90c2-ee1a69eff942 |
| ||||||
Account Name Name of the account used for the payment. Example: Business Bank Account |
| ||||||
Amount Payment amount recorded in Xero. Example: 46.00 |
| ||||||
Currency Rate Exchange rate applied to the payment. Example: 1.000000 |
| ||||||
Payment Date Date when the payment was recorded. Example: 2018-11-29T00:00:00+00:00 |
| ||||||
Payment ID Unique Xero payment identifier. Example: 99ea7f6b-c513-4066-bc27-b7c65dcd76c2 |
| ||||||
Invoice Number Number of the related invoice. Example: INV-0002 |
| ||||||
Is Reconciled Whether the payment is reconciled. Example: false |
| ||||||
Payment Type Payment type returned by Xero. Example: ACCRECPAYMENT |
| ||||||
Reference Reference saved on the payment. Example: Stripe payout 1234 |
| ||||||
Payment Status Current payment status. Example: AUTHORISED |
| ||||||
Updated Date UTC Timestamp when the payment was last updated. Example: 2018-10-20T09:16:32+00:00 |
| ||||||
Tracking Category ID Unique Xero tracking category identifier. Example: 22f10184-0deb-44ae-a312-b1f6ea70e51f |
| ||||||
Tracking Category Name Name of the tracking category. Example: Department |
| ||||||
Option Count Number of tracking options returned for the category. Example: 4 |
| ||||||
Tracking Category Status Current status of the tracking category. Example: ACTIVE |
| ||||||
Tracking Option Row ID Synthetic identifier for the tracking option row. Example: 22f10184-0deb-44ae-a312-b1f6ea70e51f_dc54c220-0140-495a-b925-3246adc0075f |
| ||||||
Tracking Option Name Name of the tracking option. Example: East |
| ||||||
Tracking Option Status Current status of the tracking option. Example: ACTIVE |
| ||||||
Tracking Category Name Name of the related tracking category. Example: Department |
| ||||||
Tracking Option ID Unique Xero tracking option identifier. Example: dc54c220-0140-495a-b925-3246adc0075f |
|
.svg){kind=logo}