Below is the Part 1: Getting data from different sources of the Level 2, Workflow 2/
I have followed the clear instructions provided on n8n Docs page and tried several times to get the expected output from the merge node.
Below is the workflow image.
And these are the configurations that I did to get expected outcome. From what I have learned till now from the course, I have applied almost every attempt but I am not getting the output.
Before this workflow, there was another Workflow 1: Merging data where I succesfully got all the expected output, and the same table customers I need to here also.
For Workflow 2 Instructions were:
Use the HTTP Request node to get data from the API endpoint that stores company data. Configure the following node parameters:
-
Method: Get
-
URL: The Dataset URL you received in the email when you signed up for this course.
-
Authentication: Generic Credential Type
-
Send Headers: Toggle to true
-
Use the Airtable node to list data from the customers table (where you updated the fields region and subregion).
-
Use the Merge node to merge data from the Airtable and HTTP Request node, based on matching the input fields for customerID.
-
Use the Sort node to sort data by orderPrice in descending order.
Everything configured same correctly.
Still I’m getting problem. Please help me out here.
Thus usually happens because Merge node is trying to match on fields that do not have identical names or data types.
Here is what to check for:
-Make sure both inputs are using the exact same field name (“customerID→customerID” vs “customerId→Customer ID”)
-Check to make sure both fields are the same type - don’t match strings with numbers
-Verify the Merge node is set to “Merge By Fields” (not Append or Multiplex)
-Check the Airtable node is returning all records, not a limited page
-Inspect each node’s output to confirm the customer IDs actually overlap
A quick fix is to add a “Set” node before the Merge and rename/convert the ID fields so they exactly match.
It is likely a mismatch issue rather than a workflow logic issue.
I checked both the output and its the exact same field name “customerID” no changes in it.
AnthonyAtXRay already nailed the most likely culprit but let me add one thing that catches people off guard specifically with Airtable + HTTP Request merges
Airtable returns your customerID as a string by default even if it looks like a number. Your API endpoint is probably returning it as an actual integer. So when the Merge node tries to match “123” === 123 it fails silently and you get zero matches or weird output
Quick way to confirm click on the output of both nodes before the Merge and look at the customerID value closely. If one shows quotes around it and the other doesn’t, that’s your problem
Fix is exactly what Anthony said drop a Set node before the Merge on whichever side has the wrong type and use an expression like {{ $json.customerID.toString() }} or {{ parseInt($json.customerID) }} to force them to match
Also double check your Airtable node isn’t silently paginating. By default it caps at 100 records. If your customers table has more than that, add a “Return All” toggle so you’re not merging incomplete data
Once those two are sorted the merge should click into place. If it’s still not working after that, screenshot the output panel of both nodes right before the Merge and paste them here — should be easy to spot from there
If you want someone to just walk through it with you live, feel free to book a session — Calendly
1 Like
**SOLVED NOW!! **
Thanks to everyone.
