Jiandaoyun icon

Jiandaoyun

Consume Jiandaoyun API

Actions16

Overview

This node interacts with the Jiandaoyun API to retrieve multiple data records from a specified app and entry. It is designed to fetch many data records in ascending order of their data IDs, supporting filtering and field selection to tailor the returned dataset.

Common scenarios where this node is beneficial include:

  • Extracting bulk form submission data for reporting or analysis.
  • Synchronizing data from Jiandaoyun forms into other systems.
  • Automating workflows that require batch processing of form entries.

For example, you can use this node to get up to 100 records from a specific form (app and entry) with optional filters applied, such as retrieving only records matching certain criteria or selecting specific fields to reduce payload size.

Properties

Name Meaning
App ID The unique identifier of the Jiandaoyun app (form) from which to retrieve data records. Required.
Entry ID The unique identifier of the entry (form section) within the app to query data from. Required.
Return Count The maximum number of data records to retrieve in one request. Must be between 1 and 100. Defaults to 100.
Additional Fields A collection of optional parameters to refine the query:
• Data ID: The ID of the last record from the previous query for pagination; leave blank if no prior data.
• Field Names or IDs: Select specific data fields to return.
• Filter (JSON): JSON object defining filter conditions to apply when querying data records.

Output

The node outputs an array of JSON objects representing the retrieved data records. Each object corresponds to a single data record from the Jiandaoyun form entry, containing key-value pairs for each field requested or available by default.

The output does not include binary data; it strictly returns JSON-formatted data records.

Dependencies

  • Requires an active Jiandaoyun API credential configured in n8n to authenticate requests.
  • The node communicates with the Jiandaoyun server URL specified in the credentials.
  • Uses POST requests to Jiandaoyun API endpoints to fetch data.

Troubleshooting

  • Error: "dataRecordIdsJson must be an array" — This error occurs if the JSON input for data record IDs is malformed or not an array when required. Ensure the JSON is correctly formatted as an array.
  • Error: "Not implemented yet" — Indicates that the selected operation or resource combination is not supported by the node implementation. Verify that the Resource is set to "Data" and Operation to "Get Many Data Records".
  • Authentication errors — Make sure the Jiandaoyun API credentials are valid and have sufficient permissions.
  • Empty results — If no data is returned, check the filter JSON syntax and values, and verify that the appId and entryId are correct.
  • Pagination issues — Use the "Data ID" field in Additional Fields to paginate through large datasets properly.

Links and References

Discussion