REST API data source - data is found in node dialog, but not sent to node action?

* Describe the bug

As per my other post, REST API data seems to be very difficult to use. In this case, it looked like a “Query Node” could access it, but the actual implementation of sending it to downstream nodes didn’t completely work.

In this case, I’m trying to use it to create a record in a collection within a ‘main’ database collection called Documents. The overall workflow looks like this:

Again, an overview is that the data is accessible in the dialog boxes, but doesn’t actually get sent to the node that would create the record.




The full error message is:

{
  "message": "(conn=3675, no: 1048, SQLState: 23000) Column 'docuseal_uuid' cannot be null\nsql: INSERT INTO `docuseal_documents` (`created_at`,`updated_at`,`filename`,`docuseal_uuid`,`url`,`preview_image_url`) VALUES (?,?,?,?,?,?); - parameters:['2025-07-07 13:42:33.502','2025-07-07 13:42:33.502',null,null,null,null]",
  "name": "SequelizeDatabaseError",
  "parent": {
    "text": "Column 'docuseal_uuid' cannot be null",
    "sql": "INSERT INTO `docuseal_documents` (`created_at`,`updated_at`,`filename`,`docuseal_uuid`,`url`,`preview_image_url`) VALUES (?,?,?,?,?,?);",
    "fatal": false,
    "errno": 1048,
    "sqlState": "23000",
    "code": "ER_BAD_NULL_ERROR",
    "parameters": [
      "2025-07-07 13:42:33.502",
      "2025-07-07 13:42:33.502",
      null,
      null,
      null,
      null
    ]
  },
  "original": {
    "text": "Column 'docuseal_uuid' cannot be null",
    "sql": "INSERT INTO `docuseal_documents` (`created_at`,`updated_at`,`filename`,`docuseal_uuid`,`url`,`preview_image_url`) VALUES (?,?,?,?,?,?);",
    "fatal": false,
    "errno": 1048,
    "sqlState": "23000",
    "code": "ER_BAD_NULL_ERROR",
    "parameters": [
      "2025-07-07 13:42:33.502",
      "2025-07-07 13:42:33.502",
      null,
      null,
      null,
      null
    ]
  },
  "sql": "INSERT INTO `docuseal_documents` (`created_at`,`updated_at`,`filename`,`docuseal_uuid`,`url`,`preview_image_url`) VALUES (?,?,?,?,?,?);",
  "parameters": [
    "2025-07-07 13:42:33.502",
    "2025-07-07 13:42:33.502",
    null,
    null,
    null,
    null
  ]
}

* Environment

  • NocoBase version:
    1.7.18
  • Database type and version:
    MariaDB
  • OS:
    Windows
  • Deployment Methods:
    docker-compose
  • Docker image version:
    latest

Could you please confirm what value is returned from the JSON Variable Mapping node, especially the docuseal_uuid field? It appears to be null, which is causing the database error when trying to create the record.

In this case, we recommend directly using the value from the Query Record node instead of passing it through a JSON Variable Mapping node. This can help avoid potential data loss or structural issues during the transfer.