I can’t get the merge to work in Chapter
| Workflow 1 | n8n Docs
name "NatanWF2"
nodes
0
parameters {}
type "n8n-nodes-base.manualTrigger"
typeVersion 1
position
0 -840
1 20
id "8bceff92-a5d0-4b7c-b890-1bdd8e668aa4"
name "When clicking ‘Test workflow’"
1
parameters
operation "search"
base
__rl true
value "appVHUcEiEIw1vMG5"
mode "list"
cachedResultName "cursoNivelUno"
cachedResultUrl "https://airtable.com/appVHUcEiEIw1vMG5"
table
__rl true
value "tbl7WvKZUJl0QzkyT"
mode "list"
cachedResultName "customer"
cachedResultUrl "https://airtable.com/appVHUcEiEIw1vMG5/tbl7WvKZUJl0QzkyT"
options
fields []
view
mode "list"
value ""
type "n8n-nodes-base.airtable"
typeVersion 2.1
position
0 -640
1 -60
id "df2692c9-4e47-47ba-82a0-2437045f70c0"
name "Airtable"
credentials
airtableTokenApi
id "lLBNdfBJ9qaHjo2w"
name "Airtable Personal Access Token account"
2
parameters
url "https://restcountries.com/v3.1/all"
options {}
type "n8n-nodes-base.httpRequest"
typeVersion 4.2
position
0 -640
1 120
id "964bd2fa-868f-422b-ba9a-6827b19a18fe"
name "HTTP Request"
3
parameters
mode "combine"
advanced true
mergeByFields
values
0
field1 "={{ $json.customerCountry }}"
field2 "={{ $json.name.common }}"
options {}
type "n8n-nodes-base.merge"
typeVersion 3
position
0 -400
1 40
id "5ccdbc69-2537-4bce-b339-23d986c1c2ba"
name "Merge"
alwaysOutputData true
4
parameters
operation "update"
base
__rl true
value "appVHUcEiEIw1vMG5"
mode "list"
cachedResultName "cursoNivelUno"
cachedResultUrl "https://airtable.com/appVHUcEiEIw1vMG5"
table
__rl true
value "tbl7WvKZUJl0QzkyT"
mode "list"
cachedResultName "customer"
cachedResultUrl "https://airtable.com/appVHUcEiEIw1vMG5/tbl7WvKZUJl0QzkyT"
columns
mappingMode "defineBelow"
value
region "={{ $('Airtable').item.json.region}}"
subregion "={{ $('Airtable').item.json.subregion }}"
matchingColumns []
schema
0
id "id"
displayName "id"
required false
defaultMatch true
display true
type "string"
readOnly true
removed true
1
id "customerID"
displayName "customerID"
required false
defaultMatch false
canBeUsedToMatch true
display true
type "number"
readOnly false
removed true
2
id "customerCountry"
displayName "customerCountry"
required false
defaultMatch false
canBeUsedToMatch true
display true
type "string"
readOnly false
removed true
3
id "customerEmail"
displayName "customerEmail"
required false
defaultMatch false
canBeUsedToMatch true
display true
type "string"
readOnly false
removed true
4
id "customerSince"
displayName "customerSince"
required false
defaultMatch false
canBeUsedToMatch true
display true
type "dateTime"
readOnly false
removed true
5
id "region"
displayName "region"
required false
defaultMatch false
canBeUsedToMatch true
display true
type "string"
readOnly false
removed false
6
id "subregion"
displayName "subregion"
required false
defaultMatch false
canBeUsedToMatch true
display true
type "string"
readOnly false
removed false
attemptToConvertTypes false
convertFieldsToString false
options {}
type "n8n-nodes-base.airtable"
typeVersion 2.1
position
0 -220
1 40
id "1f7921f0-7483-4857-989a-0155d2134f46"
name "Airtable1"
credentials
airtableTokenApi
id "lLBNdfBJ9qaHjo2w"
name "Airtable Personal Access Token account"
5
parameters
content "## Proceso de Fusión de contenidos \n\n"
height 440
width 460
color 4
type "n8n-nodes-base.stickyNote"
position
0 -720
1 -140
typeVersion 1
id "d3ba59fb-b2d4-472c-9512-d454d8322196"
name "Sticky Note"
pinData {}
connections
When clicking ‘Test workflow’
main
0
0
node "Airtable"
type "main"
index 0
1
node "HTTP Request"
type "main"
index 0
Airtable
main
0
0
node "Merge"
type "main"
index 0
HTTP Request
main
0
0
node "Merge"
type "main"
index 1
Merge
main
0
0
node "Airtable1"
type "main"
index 0
active false
settings
executionOrder "v1"
versionId "6647d2ad-c7ab-4711-be42-0262027f5ce8"
meta
templateCredsSetupCompleted true
instanceId "b8e86c9ebb32c78d5874fbd0a3b298414275d327a4963731332acb598cda54ff"
id "TjF8gCYnY0S95rNC"
tags []