-
Chargebee integration only returns 100 records. Is there a way to pull all records?
-
I don’t see credit notes available in the node. Is there a way to access this transaction type via the native integration node?
hello @jamiemcc
Seems the node doesn’t provide any options to return all records. You have to use the HTTP node and REST API for that. You can use the same credentials in the HTTP node
@jamiemcc good morning!
Use Chargebee webhooks to capture new events in real-time and save the data to a database/Data Table. Then use the https node only for incremental synchronizations or spot corrections.
To paginate through all Chargebee records via the HTTP node, you can use the next_offset parameter in their API. The pattern is:
- First request:
GET /api/v2/subscriptions?limit=100 - If the response includes
next_offset, loop back withGET /api/v2/subscriptions?limit=100&offset={{$json.next_offset}} - Stop when
next_offsetis absent from the response
In n8n, this can be done with a Loop node + HTTP Request node + IF node checking for next_offset existence. Works cleanly for credit notes too once you switch the endpoint to /credit_notes.