The bill connector reads accounts payable and receivable from BILL through its v3 API.
| Connector name | bill |
| Products | Records |
| Credentials | A BILL user's sign-in, the organization id and a developer key |
| Status | Preview: built from BILL's developer documentation, not yet on a live account |
What it pulls
| Object | Contents |
|---|---|
bill |
Vendor, invoice number and date, due date, amounts, approval and payment status, line items, created and updated times |
vendor |
Name, account type, payment terms, created and updated times |
invoice |
Customer, number, dates, amounts, status |
customer |
Name, account type, created and updated times |
payment |
Off by default; add it with objects |
Credentials
- In BILL, open Settings → Sync & Integrations → Manage developer keys and create a developer key. The organization id is on the same screen.
- Use a BILL user with a read-only role that can see payables and receivables.
The SDK signs in with these each run and keeps the session for at most 30 minutes. BILL is not on the portal's Connect button yet.
Connect
datayield connect bill -o username=ap@firm.example -o password=env:BILL_PASSWORD \
-o organizationId=<organization id> -o apiKey=env:BILL_DEV_KEYOptions
| Option | Required | Meaning |
|---|---|---|
username, password |
yes | The BILL user. The password is stored as a secret. |
organizationId |
yes | The organization id |
apiKey |
yes | The developer key. Stored as a secret. |
environment |
no | production (default) or sandbox |
baseUrl |
no | Another API address, such as a proxy |
startDate |
no | Where the first run starts |
objects |
no | Record types to pull |
New records on each run
Each object is requested with an updatedTime filter from the last successful run, sorted oldest first. BILL allows three requests at a time per developer key, and the SDK keeps to that.