Extraire des données de services pour lesquels n8n n'offre pas encore d'intégrations prêtes à l'emploi

Name: Extraire des données de services pour lesquels n8n n'offre pas encore d'intégrations prêtes à l'emploi
Rating: 4.5 (10 reviews)
Author: Creators

Débutant

Ceci est uncontenant 0 nœuds. 即便没有对应de节点ou现有操作，您仍可在flux de travail程中utilisation该应用。借助HTTP请求节点，可以实现...

Prérequis

•Aucun prérequis spécial, prêt à l'emploi après importation

Nœuds utilisés (0)

Aucun workflow correspondant trouvé

Catégorie

Aperçu du workflow

Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement

On clicking 'execute'

Ingredients in stock from recipe

Super Band

A. Ingredients Needed

B. Ingredients in stock

Merge recipe

A. Ingredients

B. Recipe quantities

A. Queen

B. Led Zeppelin

React Flow

Exporter le workflow

Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow

{
  "meta": {
    "instanceId": "8c8c5237b8e37b006a7adce87f4369350c58e41f3ca9de16196d3197f69eabcd"
  },
  "nodes": [
    {
      "id": "9971f7ab-ecc3-468b-8eb9-b58491b660bd",
      "name": "On clicking 'execute'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        1040,
        360
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bb212963-9b6f-434c-9777-3360fb456d4b",
      "name": "Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1320,
        600
      ],
      "parameters": {
        "width": 1020,
        "height": 360,
        "content": "# 3. Add items from B below items from A\n"
      },
      "typeVersion": 1
    },
    {
      "id": "cc9461f1-1016-4ef5-bc10-525942c45047",
      "name": "Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1320,
        -200
      ],
      "parameters": {
        "width": 1020,
        "height": 380,
        "content": "# 1. Keep items from A if there's a match in B\n"
      },
      "typeVersion": 1
    },
    {
      "id": "09a68f64-5b2d-43a8-acff-7c26817cc025",
      "name": "Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1320,
        200
      ],
      "parameters": {
        "width": 1020,
        "height": 380,
        "content": "# 2. Enrich items from A with matching data from B"
      },
      "typeVersion": 1
    },
    {
      "id": "bcf0c7df-fb64-4ef8-9d75-300ff9b55f40",
      "name": "Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        175,
        235
      ],
      "parameters": {
        "width": 740,
        "height": 460,
        "content": "# Aggregating data with the Merge node\n\n## The merge node is one of the most useful nodes in n8n. In this workflow we show how to merge data from two different sources (similar to SQL joins).\n\n## The most-used operations of the merge node are presented here. For more info, browse the [merge node docs](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.merge/)\n\n## Click the `Execute Workflow` button and double click on the nodes to see the input and output items."
      },
      "typeVersion": 1
    },
    {
      "id": "b418defd-f58f-4f53-9bac-b1e6611151dc",
      "name": "Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1855,
        335
      ],
      "parameters": {
        "width": 480,
        "content": "## Adds the quantity needed to each ingredient in the recipe\n\n## Similar to SQL Left join\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "017b5902-865e-4481-98d2-0a969cc09482",
      "name": "Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1855,
        -65
      ],
      "parameters": {
        "width": 480,
        "content": "## This will keep only the ingredients needed that are also in stock\n\n## Similar to SQL Inner join"
      },
      "typeVersion": 1
    },
    {
      "id": "e2b46667-da41-4448-a74d-3aa095f72619",
      "name": "Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1855,
        695
      ],
      "parameters": {
        "width": 480,
        "height": 200,
        "content": "## This will create a super band by merging Queen and Led Zeppelin\n\n## Similar to SQL Union All \n(more flexible as not requires all fields to be the same)"
      },
      "typeVersion": 1
    },
    {
      "id": "9726c9cc-cab1-44f8-8c62-2b80899af4aa",
      "name": "Ingredients in stock from recipe",
      "type": "n8n-nodes-base.merge",
      "position": [
        1600,
        -20
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "mergeByFields": {
          "values": [
            {
              "field1": "Name",
              "field2": "Name"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "42367b1e-8a5d-4b0c-bfd3-8bb3f1b63df9",
      "name": "Super Band",
      "type": "n8n-nodes-base.merge",
      "position": [
        1620,
        760
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "b4a756d8-a729-4add-aafa-9868738a6790",
      "name": "A. Ingredients Needed",
      "type": "n8n-nodes-base.code",
      "position": [
        1360,
        -100
      ],
      "parameters": {
        "jsCode": " return [\n  {\n    \"Name\": \"Flour\",\n  },\n  {\n    \"Name\": \"Eggs\",\n  },\n  {\n    \"Name\": \"Milk\",\n  },\n  {\n    \"Name\": \"Lemon\",\n  },\n  {\n    \"Name\": \"Sugar\",\n  },\n];\n"
      },
      "typeVersion": 1
    },
    {
      "id": "eb69abdc-cb89-43c5-bcd6-5f1f6383b391",
      "name": "B. Ingredients in stock",
      "type": "n8n-nodes-base.code",
      "position": [
        1360,
        40
      ],
      "parameters": {
        "jsCode": " return [\n  {\n    \"Name\": \"Eggs\",\n  },\n  {\n    \"Name\": \"Lemon\",\n  },\n  {\n    \"Name\": \"Sugar\",\n  },\n];\n"
      },
      "typeVersion": 1
    },
    {
      "id": "b01228b8-c860-4725-a0e1-00b4c11218cc",
      "name": "Merge recipe",
      "type": "n8n-nodes-base.merge",
      "position": [
        1620,
        380
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "joinMode": "enrichInput1",
        "mergeByFields": {
          "values": [
            {
              "field1": "Name",
              "field2": "Name"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "fdb8a9cb-8a85-4a9a-bd2f-c9711178333f",
      "name": "A. Ingredients",
      "type": "n8n-nodes-base.code",
      "position": [
        1360,
        300
      ],
      "parameters": {
        "jsCode": " return [\n  {\n    \"Name\": \"Flour\",\n  },\n  {\n    \"Name\": \"Eggs\",\n  },\n  {\n    \"Name\": \"Milk\",\n  },\n  {\n    \"Name\": \"Lemon\",\n  },\n  {\n    \"Name\": \"Sugar\",\n  },\n];\n"
      },
      "typeVersion": 1
    },
    {
      "id": "2ca385e5-6833-49fa-b052-abc8583b4a7a",
      "name": "B. Recipe quantities",
      "type": "n8n-nodes-base.code",
      "position": [
        1360,
        440
      ],
      "parameters": {
        "jsCode": " return [\n  {\n    \"Name\": \"Flour\",\n    \"Quantity\": \"100g\",\n  },\n  {\n    \"Name\": \"Eggs\",\n    \"Quantity\": 2,\n  },\n  {\n    \"Name\": \"Salt\",\n    \"Quantity\": \"50g\"\n  },\n  {\n    \"Name\": \"Lemon\",\n    \"Quantity\": 1,\n  },\n  {\n    \"Name\": \"Sugar\",\n    \"Quantity\": \"6tbsp\",\n  },\n];\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8e4c7da8-3700-4b1f-b937-739debf7aba4",
      "name": "A. Queen",
      "type": "n8n-nodes-base.code",
      "position": [
        1360,
        680
      ],
      "parameters": {
        "jsCode": " return [\n{\n\"FirstName\": \"John\",\n\"LastName\": \"Deacon\",\n\"Instrument\": \"Drums\",\n},\n{\n\"FirstName\": \"Freddy\",\n\"LastName\": \"Mercury\",\n\"Instrument\": \"Vocals and Piano\",\n\"Superpower\": \"Crowd control\"\n},\n{\n\"FirstName\": \"Brian\",\n\"LastName\": \"May\",\n\"Instrument\": \"Guitar\",\n},\n{\n\"FirstName\": \"Roger\",\n\"LastName\": \"Taylor\",\n\"Instrument\": \"Bass\",\n}\n];\n"
      },
      "typeVersion": 1
    },
    {
      "id": "260c7a0a-43ba-46aa-bfa8-cbbb66aca493",
      "name": "B. Led Zeppelin",
      "type": "n8n-nodes-base.code",
      "position": [
        1360,
        820
      ],
      "parameters": {
        "jsCode": " return [\n{\n\"FirstName\": \"Jimmy\",\n\"LastName\": \"Page\",\n\"Instrument\": \"Guitar\"\n},\n{\n\"FirstName\": \"Robert\",\n\"LastName\": \"Plant\",\n\"Instrument\": \"Vocals\",\n},\n{\n\"FirstName\": \"John\",\n\"LastName\": \"Bonham\",\n\"Instrument\": \"Drums\",\n},\n{\n\"FirstName\": \"John\",\n\"LastName\": \"Paul Jones\",\n\"Instrument\": \"Bass\",\n\"Second Instrument\": \"Keyboard\",\n}\n];\n"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "8e4c7da8-3700-4b1f-b937-739debf7aba4": {
      "main": [
        [
          {
            "node": "42367b1e-8a5d-4b0c-bfd3-8bb3f1b63df9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fdb8a9cb-8a85-4a9a-bd2f-c9711178333f": {
      "main": [
        [
          {
            "node": "b01228b8-c860-4725-a0e1-00b4c11218cc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "260c7a0a-43ba-46aa-bfa8-cbbb66aca493": {
      "main": [
        [
          {
            "node": "42367b1e-8a5d-4b0c-bfd3-8bb3f1b63df9",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "2ca385e5-6833-49fa-b052-abc8583b4a7a": {
      "main": [
        [
          {
            "node": "b01228b8-c860-4725-a0e1-00b4c11218cc",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "b4a756d8-a729-4add-aafa-9868738a6790": {
      "main": [
        [
          {
            "node": "9726c9cc-cab1-44f8-8c62-2b80899af4aa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9971f7ab-ecc3-468b-8eb9-b58491b660bd": {
      "main": [
        [
          {
            "node": "b4a756d8-a729-4add-aafa-9868738a6790",
            "type": "main",
            "index": 0
          },
          {
            "node": "eb69abdc-cb89-43c5-bcd6-5f1f6383b391",
            "type": "main",
            "index": 0
          },
          {
            "node": "fdb8a9cb-8a85-4a9a-bd2f-c9711178333f",
            "type": "main",
            "index": 0
          },
          {
            "node": "2ca385e5-6833-49fa-b052-abc8583b4a7a",
            "type": "main",
            "index": 0
          },
          {
            "node": "8e4c7da8-3700-4b1f-b937-739debf7aba4",
            "type": "main",
            "index": 0
          },
          {
            "node": "260c7a0a-43ba-46aa-bfa8-cbbb66aca493",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "eb69abdc-cb89-43c5-bcd6-5f1f6383b391": {
      "main": [
        [
          {
            "node": "9726c9cc-cab1-44f8-8c62-2b80899af4aa",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}

Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Débutant

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.