Joiin
v0.0.0
Check out the API docs here for more information.
Set up
Source
To get set up with the Joiin connector, you will need an API Key .
You can generate API key by following the steps:
- Log in to the Joiin app.
- Go to the Account settings
- Switch to the API Access tab
- Click generate key
You may need to wait a few minutes before the API key is active.
Extract Configuration
- Provide the Company names you want to extract data for.
- Separate multiple company names with commas (
,) in the extract configuration. - For custom reports, you must also include a valid
customReportId.
Note
While the extract configuration accepts dates in
YYYY-MM-DDformat, the Joiin API only supportsYYYY-MMformat. The day portion (DD) will be ignored, and only the year and month will be used in the request.
Features
| Feature | Supported | Notes |
|---|---|---|
| Backfill | ❌ | Not supported – each extract is for a specific time period only |
| Incremental | ❌ | Not supported – no incremental cursor or tokens |
| Date Filtering | ⚠️ Partial | Supported via startDate and endDate fields in extract payload |
Reports
| Report Name | Notes |
|---|---|
| Consolidated Trial Balance | Full trial balance by company/date |
| Consolidated Profit and Loss | P&L (income/expenses) breakdown |
| Consolidated Balance Sheet | Assets, liabilities, and equity |
| Consolidated Cashflow | Cash flow summary |
| Consolidated Custom Report | Requires customReportId in extract payload |
Limitations
Limitations
- Joiin returns a single-row consolidated report per request.
- No support for paginated or multi-row incremental exports.
- Cannot backfill over historical periods automatically — must define start and end dates explicitly.
Updated 25 days ago