BILL
DLH.io documentation for BILL
DLH.io provides the best data synchronization process from BILL, formerly Bill.com, into your Data Warehouse or Data Lake Storage so that you can integrate your other financial and operational sources for an enterprise view of your organization.
Setup Instructions
Follow the setup steps guide for configuring your BILL connection to enable data to flow into your destination via DLH.
Supported Features
Here are key features supported for this connector.
| Sync Feature | Supported | Details |
|---|---|---|
| Custom Data and Development | ✓ | Ability to enhance connector upon request |
| Historical Re-Load/Load | ✓ | |
| Incremental/Delta Load | ✓ | Gets most recent records and changes |
| Column Selection | ✓ | |
| Column Hashing | ✓ | |
| Re-Sync Table/Entity | ✓ | Select at the table level to reload data history (on next Sync Bridge run) |
| Custom Queries | Utilizing SQL Data Query Connector | |
| Custom Data | ||
| Captures Deleted Rows | ✓ | On all supported tables |
| API Sync Bridge Initiation | ✓ | |
| Priority Scheduling | ✓ | |
| Private VPC/Link | ☂ | |
| DLH Data Model Available | - |
If you have any questions about these supported features please reach out to our Customer Support team.
Details on Sync Processing
For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.
How to Video
Replicated Entities
The following BILL entities are replicated to your target destination. These are the table names you will see:
- ACTG_CLASS
- APPROVAL_POLICY
- APPROVAL_POLICY_APPROVER
- BILL
- BILL_CREDIT
- BILL_LINE_ITEM
- BILL_PAY
- CHART_OF_ACCOUNT
- CUSTOMER
- CUSTOMER_BANK_ACCOUNT
- CUSTOMER_CONTACT
- DEPARTMENT
- EMPLOYEE
- INVOICE
- INVOICE_LINE_ITEM
- INVOICE_PAY
- ITEM
- JOB
- LOCATION
- PAYMENT_TERM
- RECEIVED_PAY
- SENT_PAY
- USER
- VENDOR
- VENDOR_BANK_ACCOUNT
- VENDOR_CREDIT
- VENDOR_CREDIT_LINE_ITEM
FAQ
When the error message below appears this indicates that the username or password entered is incorrect. Please retype the credentials ensuring they are accurate
This error indicates that the Org ID that was entered is incorrect. The Org Id must start with 008 and is 20 characters in length.
Schema Details (ER Diagram)
This entity relationship diagram (ERD) for BILL provides you with information about what tables you can use for data engineering, reporting, and AI purposes out-of-the-box, and how the data is related.
Issue Handling
If any issues occur with the authorization simply return to the sources page in DLH.io, edit the source details and click the Save & Test or Authorize Your Account or Re-Authorize Account button to confirm connectivity. If any issues persist please contact our support team via the DLH.io Support Portal.