Skip to content

Create up to ten records in one call

POST
/orgs/{org}/connectors/{id}/records/{module}/batch
curl --request POST \
--url https://api.sloose.com/orgs/org_9f3c/connectors/cnn_9f2a/records/Accounts/batch \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{ "runId": "example", "automations": "example", "items": [ { "rowKey": "example", "payload": { "additionalProperty": "example" }, "keys": [ [ "Account_Number", "ac-1" ] ] } ] }'

Writes 1 to 10 new records to the destination in ONE call under an authorised run — for Zoho, one API credit where one record a call spends one each. Each record is metered as a single create meters it: admitted before the write, in order, a row on its first record; at the run’s ceiling the batch admits what fits and the rest are not sent (RUN_STOPPED), though a row this run already counted is still written. A row key may appear once a request (ROW_KEY_REPEATED), and a second insert under a key and module is refused per record (ROW_KEY_REUSED). The answer is one result per record, in the order sent: its id, or Zoho’s word for it relayed as a single create relays it — a refusal released, or a record Zoho said nothing about (zoho.unanswered), which stays counted and may exist if sent again. A failure of the whole call is every record’s. Every attempt is recorded in the run’s records under the number the ledger gave it. The destination’s own automations do not run unless the write asks for them: send automations: true to ask for them on this write; absent or false asks for none, whatever they would otherwise do on a create or an update. For a Zoho CRM that means its workflow rules, and no other kind of automation, a cadence for one, is decided by this field (#1816).

org
required

The organisation id the session was issued for. A token for one organisation can never read another.

string
Example
org_9f3c

The organisation id the session was issued for. A token for one organisation can never read another.

id
required

The connector id, from GET /orgs/{org}/connectors.

string
Example
cnn_9f2a

The connector id, from GET /orgs/{org}/connectors.

module
required

The module’s API name in the destination.

string
Example
Accounts

The module’s API name in the destination.

Media typeapplication/json
object
runId

The run from POST /entitlements/runs/authorise. Required.

string
automations

Run the destination’s own automations on this write: the import’s own switch (#1816), a boolean where only true asks, and absent, false or any other value is read as off. What it means is the destination’s: for a Zoho CRM, true asks it to run its workflow rules (trigger: ['workflow']) and off sends trigger: [], as Zoho’s own import does; Sloose does not ask Zoho to run approvals or blueprints, and a cadence, which Zoho decides on another switch, is not decided by this field.

items

One to 10 records, written in this order.

Array<object>
object
rowKey

The row this record belongs to (rowKey(flowId, row)), at most 200 characters and once a request. One record per module per key, as for a single create, and the same key for the same row across a retry or a resume. Required.

string
payload

The record’s fields, as the engine built them. Required.

object
key
additional properties
keys

The (field, value) pairs the engine indexed the record under, kept with its attempt as a single create keeps them.

Example
[
[
"Account_Number",
"ac-1"
]
]
key
additional properties
key
additional properties

One result per record, in the order sent.

Media typeapplication/json
object
results
required
Array
Any of:
object
rowKey
required
string
id
required

Created: the record’s id in the destination.

string
Example
{
"results": [
{
"code": "RUN_STOPPED",
"stop": {
"stopped": "LIMIT_ROWS_PER_RUN",
"stoppedBy": "plan"
},
"written": false
}
]
}

No items, more than 10 (BATCH_SIZE), a record with no payload or row key, a row key over 200 characters, or one named twice (ROW_KEY_REPEATED). Nothing was admitted or sent. Or the module is a subform (SUBFORM_NOT_WRITABLE, written: false): its rows are written inside their parent’s record, never as records of their own.

Media typeapplication/json
object
error
required
string
code
string
written
boolean
key
additional properties
Example
{
"written": false
}

No bearer, or one that no longer resolves: a session that is unknown or expired (code: AUTH_REQUIRED), or an API token that was revoked or expired (TOKEN_REVOKED, TOKEN_EXPIRED), whose organisation is gone (ORG_NOT_FOUND) or whose member or user row is (MEMBERSHIP_GONE).

Media typeapplication/json

The error envelope every non-2xx answer uses.

object
error
required

Human-readable explanation.

string
code

Machine-readable reason. Absent on a few legacy 400s.

string
key
additional properties
Examplegenerated
{
"error": "example",
"code": "example"
}

The run has been stopped and nothing was written (code: RUN_STOPPED, with stop); the run is an import’s and this is not the session or token that authorised it (code: NOT_YOUR_RUN); or the bearer’s role is too low, or it was issued for a different organisation. Like every route behind a session: a session signed in but in no organisation is refused code: NO_ORG, a banned person code: BANNED, and a closed organisation code: ORG_CLOSED.

Media typeapplication/json
Any of:
object
error
required
string
code
required
string
Allowed values: RUN_STOPPED
stop
required
object
stopped
required
string
Allowed values: LIMIT_ROWS_PER_RUN
rowsPerRun
required
number
stoppedBy
required
string
Allowed values: plan declaration
rowsWrittenTotal
required
number
Example
{
"code": "RUN_STOPPED",
"stop": {
"stopped": "LIMIT_ROWS_PER_RUN",
"stoppedBy": "plan"
}
}

No such connector, or it is not visible to this session (NOT_FOUND); no such run (RUN_NOT_FOUND); or the connection has no module of that name — only its modules, as its discovery read them, are asked of the CRM (MODULE_NOT_FOUND).

Media typeapplication/json

The error envelope every non-2xx answer uses.

object
error
required

Human-readable explanation.

string
code

Machine-readable reason. Absent on a few legacy 400s.

string
key
additional properties
Examplegenerated
{
"error": "example",
"code": "example"
}

The run is not authorised to write, the run is no longer authorised, the run was authorised for a different connector (RUN_CONNECTOR_MISMATCH), or the run is an import’s and no longer holds it — its lease ran out and the import was released (LEASE_LOST).

Media typeapplication/json
object
error
required
string
key
additional properties
Examplegenerated
{
"error": "example"
}

Zoho is throttling how often this connection’s access is renewed — ten tokens from one grant in ten minutes — so nothing was sent (code: CONNECTION_THROTTLED; written: false on a write). Retry-After says when to ask again. The connection is kept: only a grant Zoho refuses ends it. A renewal throttled after the call reached Zoho is Zoho’s rate limit, relayed as a 502 with zoho.rateLimited.

Or the CRM’s API allowance for the last 24 hours is spent (zoho.quotaSpent: true, zoho.rateLimited: true, zoho.retryable: false), said one of two ways. Zoho itself refused the call (zoho.code: TOO_MANY_REQUESTS, credits left 0): relayed as this 429, never a 502, since asking again soon is refused again. Or the tenant’s gate refused it before it was sent, because Zoho had already said so: this API’s own refusal, with no zoho (code: DAILY_ALLOWANCE_SPENT; written: false on a write). Neither carries Retry-After: Zoho’s day is a rolling 24 hours and it names no time at which credits return, so Sloose lets one call a minute through to ask, and the first one answered is the allowance’s return. GET …/credits says whether the day is held spent (spent, spentAt). A system that does name its renewal is answered with Retry-After until then.

Media typeapplication/json
object
error
required
string
code
required

Why: CONNECTION_UNAVAILABLE (502) when a Zoho token for the connection will not refresh, CONNECTION_THROTTLED (429) when Zoho is throttling its renewal — ten tokens from one grant in ten minutes — and the connection is kept, and DAILY_ALLOWANCE_SPENT (429) when the connected system said a daily allowance the call draws on is spent, which waiting seconds does not bring back.

string
written

On a write: refused before the record was sent to the CRM, so nothing was written and a retry makes no second record. Absent from a read.

boolean
key
additional properties
Example
{
"written": false
}

Zoho is rate-limiting (zoho.unanswered false: nothing was done), or did not answer — it could not be reached, failed on its side, or answered without saying what it did (zoho.unanswered true: what was asked may have been done). Or this API could not use the connection before anything was sent — a Zoho token that will not refresh (code: CONNECTION_UNAVAILABLE) — and says so on a write with written: false: nothing was written.

Media typeapplication/json
Any of:
object
error
required
string
zoho
required
object
code
required
string | null
status
required
number | null
details
retryable
required
boolean
response
unanswered
required

True when Zoho gave no answer that says what was done — the connection dropped or timed out, Zoho failed on its side (a 5xx, or the same for the one record inside a 2xx), the answer was lost after its status or was not JSON, or Zoho said it made the record without saying which — so what was asked may have been done all the same: a create sent again after one may make a second record. A write that went unanswered stays counted, and its row may be written again for nothing. False when Zoho answered by declining (a 4xx, or a per-record refusal inside a 2xx), which made nothing.

boolean
rateLimited

True when Zoho asked for fewer calls and declined this one (TOO_MANY_REQUESTS): nothing was done, and the same call a little later may land — a write included, since a declined one made nothing. Absent from an older API.

boolean
retryAfterMs

How long Zoho asked to be left alone before the next call, in milliseconds, from its Retry-After; also sent as this response’s own Retry-After, in seconds. Null when it said nothing.

number | null
quotaSpent

True when the rate limit is the CRM’s daily allowance of API calls used up — a 429 whose X-API-CREDITS-REMAINING says none are left — which waiting seconds does not bring back. Without that header the two limits cannot be told apart, and this is false.

boolean
Example
{
"written": false
}

The restore switch is on (code: MAINTENANCE): every route but /health and /robots.txt is refused before anything is read, except the operator’s own POST /staff/people/{id}/delete with the ADMIN_TOKEN. Sloose is down for maintenance. Please try again in a few minutes.

Media typeapplication/json
object
error
required
string
code
required
string
Allowed value: MAINTENANCE
Example
{
"code": "MAINTENANCE"
}
Retry-After
integer

Seconds until asking again is worth it (300 while the switch is on).

Report a problem with this page

sloose.com