Handle Null Values in Tables and JSON

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "id": "3",
  "name": "Null values in table and json",
  "nodes": [
    {
      "parameters": {},
      "id": "e3a1c27b-0cf3-4afa-9e53-f4ca0f86ec3b",
      "name": "Start",
      "type": "n8n-nodes-base.start",
      "typeVersion": 1,
      "position": [
        -880,
        200
      ]
    },
    {
      "parameters": {
        "url": "https://api.mixcloud.com/csabatuncsik/cloudcasts",
        "options": {
          "response": {
            "response": {
              "responseFormat": "json"
            }
          }
        }
      },
      "id": "36bc674b-b8aa-46d0-a81c-ed8b81a9feea",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 3,
      "position": [
        -660,
        200
      ]
    },
    {
      "parameters": {
        "keepOnlySet": true,
        "values": {
          "boolean": [
            {}
          ]
        },
        "options": {}
      },
      "id": "9f6f626d-ec6d-4408-bdae-3ed71f6c87c6",
      "name": "Set",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        -440,
        200
      ]
    },
    {
      "parameters": {
        "functionCode": "// Code here will run only once, no matter how many input items there are.\n// More info and help:https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.function/\n// Tip: You can use luxon for dates and $jmespath for querying JSON structures\n\n// Loop over inputs and add a new field called 'myNewField' to the JSON of each one\nfor (item of items) {\n  item.json = {\n    data: null,\n    number: 1,\n    text: '1',\n    empty_string: \"\",\n    empty_array: [],\n    config: {\n      type: undefined,\n      part: null,\n      items: [],\n      empty_object: {}\n    },\n    meta: {}\n  };\n}\n\n// You can write logs to the browser console\nconsole.log('Done!');\n\nreturn items;"
      },
      "id": "c6904284-2bc1-4f2e-8b76-51a3814617b1",
      "name": "Function",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        -680,
        440
      ]
    },
    {
      "parameters": {
        "options": {}
      },
      "id": "bcd215b9-1021-43b8-8d1a-1e5307e570eb",
      "name": "Set1",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        -460,
        440
      ]
    }
  ],
  "connections": {
    "Start": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          },
          {
            "node": "Function",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Set",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Function": {
      "main": [
        [
          {
            "node": "Set1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "saveExecutionProgress": "DEFAULT",
    "saveManualExecutions": true,
    "callerPolicy": "workflowsFromSameOwner"
  },
  "triggerCount": 0,
  "versionId": "46c5a65f-3fee-43c8-a792-1c779e939cb7",
  "owner": {
    "type": "personal",
    "personalEmail": "csaba@n8n.io"
  }
}

About this workflow

Null values in table and json. Uses start, httpRequest. Manual trigger; 5 nodes.

Source: https://github.com/cstuncsik/n8n-env-test/blob/e63c9d292c1cf01fac4030bd5c388d1625448b9a/workflows/3.json — original creator credit. Request a take-down →

More Web Scraping workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.