Convert csv file to binary

Questions
1

I am trying to to send multiple queries fraom a csv file to an API using HTTPRequest node.
I am trying to convert a csv file to binary using the following javascript code in a code node on an windows 10 pro desktop installation of n8n:

const csv = require(‘csv-parser’);
const fs = require(‘fs’);

const csvFilePath = ‘“C:\Users\fdavi.n8n\binaryData\imageURLs.csv”’;
const binaryFilePath = ‘“C:\Users\fdavi.n8n\binaryData\imageURLs.bin”’;

// Read the CSV file and encode it as binary data
const urls = [];
fs.createReadStream(csvFilePath)
.pipe(csv())
.on(‘data’, (data) => {
urls.push(data.url);
})
.on(‘end’, () => {
const binaryData = urls.join(‘\n’).trimEnd();
const buffer = Buffer.from(binaryData, ‘utf-8’);

// Write the binary data to a file
fs.writeFileSync(binaryFilePath, buffer);

console.log('CSV file converted to binary successfully.');
// Continue with the rest of your workflow
// ...

});

I am trying to to send multiple queries to an API using HTTPRequest node

ERROR: Cannot find module ‘csv-parser’ [line 1]

This is in a code node that I have not implemented in a workflow yet.

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 0.216.2
  • Database (default: SQLite): SQLLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main):**
  • Running n8n via (Docker, npm, n8n cloud, desktop app): desktop app
  • Operating system: Windows 10 Pro
3

Hi @fdavidg, you wouldn’t need the Code node to read a file from your file system and have it available as a binary item in n8n.

On the old desktop app ([email protected]) using Windows you can use the Read Binary Files node like so:

This will give you a binary item in n8n ready to be used elsewhere:

image
image1024×824 45.9 KB

One thing worth pointing out here is that the path is specified using forward slashes rather than the usual backward ones Windows uses, for example C:/Users/User/Downloads/addresses.csv or C:/Users/fdavi.n8n/binaryData/imageURLs.csv in your case.

For parsing the file you can then use the Spreadsheet File node in n8n.

If instead of using n8n nodes you want to write code including an external npm module such as csv-parser instead you’d need to make sure it’s available to n8n and configure the respective NODE_FUNCTION_ALLOW_EXTERNAL environment variable to allow its use (docs).

4

Hi MutedJam,

Thank you very much for your prompt reply!
Also thank you for the correct way to specify the path. I always have trouble with that, too!

I am trying to convert a csv file to binary so I can use the Read Binary Data node, or is that not necessary?

Frank

1 Like
5

Perhaps you can confirm what exactly you mean by binary (or what you want to do with the result)?

n8n would have a binary object in memory after the Read Binary Files step. This object could then be attached to an email or uploaded to Google Drive for example.

6

I have a file imageURLs.csv that is as follows:

url
https://target.scene7.com/is/image/Target/GUEST_8754939d-d28e-4647-a7c2-fe4e730bf314?wid=325&hei=325&qlt=80&fmt=pjpeg
https://target.scene7.com/is/image/Target/GUEST_f2deab41-8424-4452-b09f-d22cc529401d?wid=325&hei=325&qlt=80&fmt=pjpeg
https://target.scene7.com/is/image/Target/GUEST_e435c29d-b59c-4097-bceb-f8851982b9f2?wid=325&hei=325&qlt=80&fmt=pjpeg
https://target.scene7.com/is/image/Target/GUEST_f7ccc35c-404e-4724-9c9f-46ee4b2d28c4?wid=325&hei=325&qlt=80&fmt=pjpeg
https://target.scene7.com/is/image/Target/GUEST_1e3676b8-4471-4ce1-b1a7-3697894b4290?wid=325&hei=325&qlt=80&fmt=pjpeg
https://target.scene7.com/is/image/Target/GUEST_02a872c9-514d-4a8b-a168-062870297377?wid=325&hei=325&qlt=80&fmt=pjpeg
https://target.scene7.com/is/image/Target/GUEST_183c07d5-faa7-4f34-a58c-cbec8df3a258?wid=325&hei=325&qlt=80&fmt=pjpeg
https://target.scene7.com/is/image/Target/GUEST_9672b2f2-f5b7-4b9b-bdbd-1fdd79e1c89f?wid=325&hei=325&qlt=80&fmt=pjpeg
https://target.scene7.com/is/image/Target/GUEST_aa85573c-e776-4c63-a337-885a3cf84b54?wid=325&hei=325&qlt=80&fmt=pjpeg

I want to be able to send the individual URLs to the HTTPRequest Parameter to query an API. I understand that an excel csv file is a text file and not a binary file.

7

Thanks so much for confirming and sharing your example @fdavidg! After reading your file from the file system using the Read Binary Files node as suggested in my first answer, you can indeed open it in n8n using the Spreadsheet File node. After doing so, you can use the data in your HTTP Request node.

Here’s a quick example workflow showing the idea (here I am downloading the example file from a web location, so the workflow can run out of the box, but you can simply swap in the Read Binary Files node):

This will submit the URL from your CSV file in a query parameter to the API you are calling, making one request per URL:

image
image1919×767 116 KB

Hope this helps!

1 Like
8

I would like to thank everybody for all their help!

This is the workflow that I have been trying to put together. I have a long list of URLs that I want to submit to an RapidAPI API. I the want save each response to a spread sheet file. My question(s) revolve around writting the javascript code for the n8n code node and how to handle the HTTP Request node’s response. If I split the list of URLs into a batch of 10 the HTTP Request node processes all 10 requests. Do I have to do anything special in the javascript in the code node? Will it process each reply separately? OR should I include the code, spreadsheet, and write binary nodes as part of the split into batch node loop?
Thank you for any and all help with understanding this!

1 Like
9

Hi @fdavidg, I am not quite sure what the Code node should do in the workflow you have shared. How does the JSON data coming from your HTTP Request node look like and what do you want your Code node to do with it?

On a more general note, it might be easier to avoid using the Split In Batches + Wait node in your scenario and simply configure the batching options on the HTTP Request node. You can find these after clicking “Add Option”:

image

10

First thank you for the tip about configuring the batch options on the HTTP Request node, I did not know about it at all.

I am embarrassed to provide this workflow. It’s not very good, but I am learning.

I have a list of images as URLs in a csv file that I want to run through a RapidAPI API. I them want to parse the result an capture the original URL, and the API response and save the results to a spreadsheet and then write the spreadsheet to a file on my local harddisk.

I addes the bottom part of the workflow; code node, googleLensResults5 node and Write Binary File2 to the workflow after I discovered that the Split In Batches node done output collected all the results of the loops.

Right now the googleLensResults node just spins endlessly.

I apologize for the mess of a workflow I am sending you, but then again I am just starting out.

Thank you for any and all help!

Frank Gunseor

11

I am sorry for the trouble @fdavidg. I know when this post was written you were using n8n desktop 0.216.2. Are you also seeing this problem when using a more recent version of n8n via Docker?

Keep in mind that you’d need to update your path accordingly. When using the -v C:\Users\fdavidg\.n8n:/home/node/.n8n option in your docker run command, the C:\Users\fdavidg\.n8n path on your desktop machine would be available to your n8n docker container as /home/node/.n8n.

If this problem keeps happening, can you confirm if you are seeing any error message in your terminal confirming what might have gone wrong?

12

Hello,

Thank you for your prompt reply!

Let me explain. I am trying to get up to speed with n8n.

When I discover that version 1.0 was in the wings and the desktop was depricated, I did two things. I installed n8n on my Windows 10 Pro machine using npm (I am at version 0.233.0), I also started runing the bets of vesion 1.0 using Docker on my other Windows 10 Pro machine (both are runing on HP Z800 hardware).

I am testing the Docker version right now.

The n8n v0.233.0 running under npm is my main machine.

Here is some sample output from the n8n HTTP Request node:


[
{
"status":
"OK",
"request_id":
"a6913921-21c6-4358-a217-0b20a16ba31d",
"parameters":
{
"**url**":
"https://target.scene7.com/is/image/Target/GUEST_9672b2f2-f5b7-4b9b-bdbd-1fdd79e1c89f?wid=325&hei=325&qlt=80&fmt=pjpeg",
"language":
"en",
"country":
"us"
},
"data":
{
"**visual_matches**":
[
{
"position":
1,
"**title**":
"Idahoan Buttery Homestyle Mashed Potatoes 2 Pack",
"**link**":
"https://www.ebay.com/itm/256017912508",
"**source**":
"ebay.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT5NXsW5qpQoNKtvnEC0sNL88H54opWmBBYIh2gQ3U_SGUU-yc8xV_BfeECVq4HYfwroQsx3k4lpMvjDByZM4KvONyK63j7aI6RPQrDFwRa9lo",
"**thumbnai**l":
"https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcRQ-0RuqTP5LhUaWnJKCLNqdWpvHWsze4ze2mq5lSNm6enRAUcJ",
"**price**":
"$13.95",
"availability":
"In stock"
},
{
"position":
2,
"title":
"Idahoan Buttery Homestyle Mashed Potatoes, 4oz (Single Pouch)",
"link":
"https://shop.idahoan.com/products/100559",
"source":
"idahoan.com",
"source_icon":
"https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcQPnZfNLAf50G-3QD7hYBB32hTp22owau2h5I4JY-YViOBSLUKJNtj_na6xIhpVXcjp14bOUTULrd1ztl3I-2D6N7XgYM2uF0YSHJaqXubYc_ikxKJZ",
"thumbnail":
"https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcS7yDICFOtEn1l26t3CPXSZ0ZMCCCIG8_YYTMOqN_hJnC2GcmdN",
"price":
"$1.99",
"availability":
"In stock"
},
{
"position":
3,
"title":
"Idahoan Buttery Homestyle Mashed",
"link":
"https://www.ndmmarket.com/shop/grocery/packaged_meals_and_side_dishes/potatoes_and_stuffing/idahoan_buttery_homestyle_mashed/p/22061#!/?department_id=453618",
"source":
"ndmmarket.com",
"source_icon":
"https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRTm9uKqxg1o3hrxCI4BB5E6u8TfEaYCy7WFPXmQ3pmDtIhHccCgPMHb8MZOofxYWUe4K4UqimqK7H14KCwO8Uv_FOYtJkbkYrVaPegYuIgkfjktGB3Aw",
"thumbnail":
"https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcROFsR9l7QkEkbKt14jx7bO3yHn-8Z8P3kI1_fyPjOz2mh6v2qU",
"price":
"$1.99"
}
],
"products":
[
{
"title":
"Idahoan Mashed Potatoes",
"link":
"https://www.google.com/search?q=Idahoan+Mashed+Potatoes&source=.lens.button&hl=en&gl=US",
"images":
[
{
"title":
"Image for Idahoan Mashed Potatoes",
"link":
"https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcROFsR9l7QkEkbKt14jx7bO3yHn-8Z8P3kI1_fyPjOz2mh6v2qU",
"source":
"https://www.google.com/imgres?h=512&w=512&tbnh=225&tbnw=225&osm=1&hcb=1&source=lens-native&usg=AI4_-kQI5edN0DkrBbvudxJrGOfdf4w5sw&imgurl=https://encrypted-tbn2.gstatic.com/images?q%3Dtbn:ANd9GcTc_vhLbyXTrONlT-fQNHKlf7ZJi-EEsQ0Uic4-ZyXhlsfVCNAi&imgrefurl=https://www.ndmmarket.com/shop/grocery/packaged_meals_and_side_dishes/potatoes_and_stuffing/idahoan_buttery_homestyle_mashed/p/22061%23!/?department_id%3D453618&tbnid=gqPf-IbCXQKGmM&docid=uZAjOJEkuhOxnM&hcb=1",
"width":
225,
"height":
225
}
],
"offers":
[
{
"price":
"$1.99",
"link":
"https://www.ndmmarket.com/shop/grocery/packaged_meals_and_side_dishes/potatoes_and_stuffing/idahoan_buttery_homestyle_mashed/p/22061#!/?department_id=453618",
"source":
"ndmmarket.com",
"source_icon":
"https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRTm9uKqxg1o3hrxCI4BB5E6u8TfEaYCy7WFPXmQ3pmDtIhHccCgPMHb8MZOofxYWUe4K4UqimqK7H14KCwO8Uv_FOYtJkbkYrVaPegYuIgkfjktGB3Aw"
},
{
"price":
"$1.50",
"link":
"https://www.heb.com/product-detail/idahoan-buttery-homestyle-reduced-sodium-mashed-potatoes/2133447",
"source":
"heb.com",
"source_icon":
"https://encrypted-tbn3.gstatic.com/favicon-tbn?q=tbn:ANd9GcSDo1_1PdYBgWEg_FFPAukmi-UIvyJKUZVtA4SNPubV75twQic1GmQJV86x-ZgcHhLASui11lxn_STj1qxNMlT9ZIfCv-5jtG4ynyKNPHb4Lg"
},
{
"price":
"$2.99",
"link":
"https://www.shopfamilyfare.com/shop/pantry/dry_goods/potatoes/idahoan_buttery_homestyle_mashed_family_size/p/539990",
"source":
"shopfamilyfare.com",
"source_icon":
"https://encrypted-tbn3.gstatic.com/favicon-tbn?q=tbn:ANd9GcSr69f4PKFIn6ms9acL3nVwAkkRVfUe0NdlY_HlH91-uLQ1t-V0-C7_JvWzSXE_oKtT0ZNU47B_K_sTGYBOoYr-k8W7pYA1IEV8NOO8LB7a6eBkQlcGpfxnmSch"
}
]
}
],
"text_matches":
[
"HOMEMADE TASTE IN MINUTES",
"IDAHOAN",
"H BUTTERY Fle HOMESTYLE",
"MASHED POTATOES",
"America FAVORITE MASHED",
"41/3 CUP) SERVINGS",
"NET WT 402 1113.4g)"
],
"text_language":
"en",
"detected_objects":
[
{
"box":
{
"left":
0.5030769,
"top":
0.5030769,
"width":
0.61230767,
"height":
0.9692308
},
"detections":
[
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
79.009415
},
{
"label":
"Instant mashed potatoes",
"type":
"FRYWOK",
"confidence":
78.99941
}
]
},
{
"box":
{
"left":
0.4969231,
"top":
0.80923074,
"width":
0.5446154,
"height":
0.34461537
},
"detections":
[
{
"label":
"Instant mashed potatoes",
"type":
"FRYWOK",
"confidence":
78.99941
},
{
"label":
"Shoppers Value Mashed Potatoes",
"type":
"ROSTI",
"confidence":
71.603096
},
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
0.0001
}
]
},
{
"box":
{
"left":
0.5014663,
"top":
0.5485392,
"width":
0.4430769,
"height":
0.036923077
},
"detections":
[
{
"label":
"Mashed potato",
"type":
"GOLDMINE",
"confidence":
77.08536
},
{
"label":
"Potato",
"type":
"GOLDMINE",
"confidence":
76.53946
}
]
},
{
"box":
{
"left":
0.4993917,
"top":
0.24471018,
"width":
0.42461538,
"height":
0.101538464
},
"detections":
[
{
"label":
"Idaho Fresh-Pak Inc.",
"type":
"GOLDMINE",
"confidence":
78.740845
},
{
"label":
"Idahoan",
"type":
"GOLDMINE",
"confidence":
78.97941
}
]
},
{
"box":
{
"left":
0.6827566,
"top":
0.79784524,
"width":
0.073846154,
"height":
0.024615385
},
"detections":
[
{
"label":
"Mashed potato",
"type":
"GOLDMINE",
"confidence":
77.08536
}
]
}
],
"searched_object":
{
"box":
{
"left":
0.5030769,
"top":
0.5030769,
"width":
0.61230767,
"height":
0.9692308
},
"detections":
[
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
79.009415
},
{
"label":
"Instant mashed potatoes",
"type":
"FRYWOK",
"confidence":
78.99941
}
]
},
"reverse_image_search_link":
"https://www.google.com/search?tbs=sbi:AMhZZivJ4EfGIE5tyWQ61a12akQDgSbUS7BvkX0jqyoSIA5ihNbs7avPEXzBBZpI-bDyjNsnhfqU-UmQAYE0GWkazy-jTNFTLEecXDjnOSNlFEqUvhYhzCGDMD5TzFGwr1S2PIIBb8vLPaknf0y41gMng2niOyqKCw"
}
},
{
"status":
"OK",
"request_id":
"f5c13db3-fa73-4a83-9f8d-22f75ef8f25d",
"parameters":
{
"url":
"https://target.scene7.com/is/image/Target/GUEST_8754939d-d28e-4647-a7c2-fe4e730bf314?wid=325&hei=325&qlt=80&fmt=pjpeg",
"language":
"en",
"country":
"us"
},
"data":
{
"visual_matches":
[
{
"position":
1,
"title":
"Tender Noodles, Signature Flavors | Annie Chun's Noodle Bowls",
"link":
"https://anniechun.com/products/noodle-bowls/",
"source":
"anniechun.com",
"source_icon":
"https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcSVJVky3wCJajbUfPmT1UvmgShshLYSEZEgkqAmrpGyHfg38vdmqFwVD6liH3kAk8JU6g1cYnYc1X-190end9LjZr4Kb_LLPVIj0MZGGRdIufjJ",
"thumbnail":
"https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcQmOzJre_tbC-xCrzwmtH5v4Kir3W2bIOjSOKbIrLBKSwUynPwT"
},
{
"position":
2,
"title":
"Annie Chun's Vegan Noodle Bowl Pad Thai - 8.1oz",
"link":
"https://www.target.com/p/annie-chun-39-s-vegan-noodle-bowl-pad-thai-8-1oz/-/A-15415187",
"source":
"target.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT0NBxJbjhPo7fICwO8po_ZW5pqh0MaK0k-HxaZx_CQiBFeb6PhctPRiZG-7YFbml47uEZPmZ016IktIlsLn58o0Cj7TwvwFDnnsGuimBQWi5Eyvw",
"thumbnail":
"https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcRAmMnE9vlcfUCGoGxVnEPnEOuT_EEn6NnnErmsiFjU5N7A6cfi",
"price":
"$3.19",
"availability":
"In stock"
},
{
"position":
3,
"title":
"Annie Chun's Noodle Bowl Pad Thai Vegan - 8.1 oz pkg | Stop & Shop",
"link":
"https://stopandshop.com/product/172218/?source=static-page",
"source":
"stopandshop.com",
"source_icon":
"https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTt7Gh0GLt1rqboofYu4j3l2D5IqB4C-he98u6jzpjy8ufsV09tdyzC825mgl8vSU-lBzx0DVM81mKf2oINydJZZzzwFytlFLb77UCYj8BaLEMD4Yw",
"thumbnail":
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSVUZfl9mv5PoPgWe3CdKTO4jd1_dTP83PfBUbsTcGEyTQqFS_Z"
},
{
"position":
4,
"title":
"Annie Chun's Noodle Bowls - Case Of 6 - 8.1 Oz",
"link":
"https://puremodernliving.com/annie-chuns-noodle-bowls-case-of-6-8-1-oz/",
"source":
"puremodernliving.com",
"source_icon":
"https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRYohK0m3hr925v_amPaKkVemBOOohW2dMTEqeZXSV5LYyTpHMxZehF2AbNoMVWnj6zJaih5JXwO8_b3eT3MPjoFTClRMxiMbGxJblyA8wF9I3Ekvt-NyAfSQ",
"thumbnail":
"https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcSfhCf0BaauRtQOsu_9s_2Q3vRtD0a0NCl0j54r55B7ftLi6cwg",
"price":
"$30.99",
"availability":
"In stock"
},
{
"position":
5,
"title":
"Annie Chun's Noodle Bowl, Thai-style Pad Thai, Vegan, Non Gmo Project",
"link":
"https://www.ebay.com/itm/175683234647",
"source":
"ebay.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT5NXsW5qpQoNKtvnEC0sNL88H54opWmBBYIh2gQ3U_SGUU-yc8xV_BfeECVq4HYfwroQsx3k4lpMvjDByZM4KvONyK63j7aI6RPQrDFwRa9lo",
"thumbnail":
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRXeeiYeoVlRdjg5c6tLX_tnfr43LsvRk__p2hss3_NDr0K4lni",
"price":
"$28.94",
"availability":
"In stock"
},
{
"position":
6,
"title":
"Annie Chun's Noodle Bowl, Pad Thai, Thai-Style",
"link":
"https://www.freshbybrookshires.com/product/annie-chuns-noodle-bowl-pad-thai-thaistyle-00765667100806",
"source":
"freshbybrookshires.com",
"source_icon":
"https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcQMH_WI_lGqVfY9ovaRHiFlsUKKleiSKUYQFZYNn-36_BMBzl2vOE69deWAUlDyxfvP4ST3ubz2Z4Hw2fhk41-9Q1qeyFbDPS4yGg3nCvThHyXw1ncD_ySMLk9fl5OJOw",
"thumbnail":
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSHfggji3pijE3G20CBj_nBe-B261zrPjmw22N8u8Y8zZlTT5bE"
},
{
"position":
7,
"title":
"Packaged Asian Meals - Order Online & Save | Stop & Shop",
"link":
"https://stopandshop.com/groceries/rice-grains-pasta-beans/packaged-meals-sides/packaged-asian-meals.html",
"source":
"stopandshop.com",
"source_icon":
"https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTt7Gh0GLt1rqboofYu4j3l2D5IqB4C-he98u6jzpjy8ufsV09tdyzC825mgl8vSU-lBzx0DVM81mKf2oINydJZZzzwFytlFLb77UCYj8BaLEMD4Yw",
"thumbnail":
"https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcRs8i_L70rVB1UOpgojW3BDL9xxZc_Gui9ynrJtAgfWIup0_YvF"
},
{
"position":
8,
"title":
"Pad Thai Noodle Bowl, 8.1 oz at Whole Foods Market",
"link":
"https://www.wholefoodsmarket.com/product/annie-chuns-pad-thai-noodle-bowl-81-oz-b000wcybl0",
"source":
"wholefoodsmarket.com",
"source_icon":
"https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcR9zWC-AOzImC-QNmo56NYAe_9HKBATgy8VJsfM4WGt1MD2q8PsnzSWqL2cFF1Q-COE03PmF31Uuw3DY5EgfqjYxBoowx0orTBi_XGnoLI9wknZUtQhf8t7lhKKs2g",
"thumbnail":
"https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcRJLxpssSKdQcj3zYBlSkt7BrsouulZxK2LEPAftO-nvqcps0q8"
},
{
"position":
9,
"title":
"Annie Chun's Noodle Bowls - Case of 6 - 8.1 OZ, 8.1 OZ - Kroger",
"link":
"https://www.kroger.com/p/annie-chun-s-noodle-bowls-case-of-6-8-1-oz/1076566710080",
"source":
"kroger.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcTT75GJwlN-aLUTLgU1MLWiLNmUlufvz8Fs82dHBoWwerye7mGKYkshDGTtacmJC9NB8IO7CZXpCtpvYcGkioZ0ELKJT7uckBgAF5g1znQBdofOEQ",
"thumbnail":
"https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcS-98hGP4ZPdDJZ97tvCEFaCmxuJF6jiKluPdmtFNMb-_2x3OR9"
},
{
"position":
10,
"title":
"Annie Chun's Teriyaki Noodle Bowl - Case of 6 - 7.8 oz., 6 Pack/7.8 Ounce Each - Kroger",
"link":
"https://www.kroger.com/p/annie-chun-s-teriyaki-noodle-bowl-case-of-6-7-8-oz-/0074956925210",
"source":
"kroger.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcTT75GJwlN-aLUTLgU1MLWiLNmUlufvz8Fs82dHBoWwerye7mGKYkshDGTtacmJC9NB8IO7CZXpCtpvYcGkioZ0ELKJT7uckBgAF5g1znQBdofOEQ",
"thumbnail":
"https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcSOD1OV0hWHccY59BAVRmvjHRm5QPbHL7HyMEIltwRmBm_BgNLV"
},
{
"position":
11,
"title":
"Annie Chun's Noodle Bowl Pad Thai Vegan",
"link":
"https://giantfood.com/product/172218/?source=static-page",
"source":
"giantfood.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcQeft9puy91ZHsycrSPlafha8UzXKedP3uWaMrtsyqm37MutA_g-ut_l1R8OWdlLgakTkSz_7eo59n2qo6TXhR6wUPO4eczfq0DEGnVfBGD1Y_l",
"thumbnail":
"https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcSpnalPs3f1nvFp9onmwovpaqEMIKtKVKD9px3UQhCZVqMIrnnw",
"price":
"$5.29"
},
{
"position":
12,
"title":
"Annie Chun's Vegan Noodle Bowl Korean Sweet Chili - 8oz",
"link":
"https://www.target.com/p/annie-chun-39-s-vegan-noodle-bowl-korean-sweet-chili-8oz/-/A-15415186",
"source":
"target.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT0NBxJbjhPo7fICwO8po_ZW5pqh0MaK0k-HxaZx_CQiBFeb6PhctPRiZG-7YFbml47uEZPmZ016IktIlsLn58o0Cj7TwvwFDnnsGuimBQWi5Eyvw",
"thumbnail":
"https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcSCoIGYCbQBXUvxHDmqRAkyJjhKBEh2lkRWQJ8DebD6oQ9Zj1kq",
"price":
"$3.19",
"availability":
"In stock",
"rating":
4.2,
"reviews":
31
}
],
"products":
[
{
"title":
"Annie Chun's Pad Thai Noodle Bowl",
"rating":
4.2,
"reviews":
31,
"link":
"https://www.google.com/search?q=Annie+Chun%27s+Pad+Thai+Noodle+Bowl&source=.lens.button&hl=en&gl=US",
"images":
[
{
"title":
"Image for Annie Chun's Pad Thai Noodle Bowl",
"link":
"https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcS_iTpyjGkhLR0p90P950bm3ZIdzdbOJ7QugyunWpiFboI_2rHE",
"source":
"https://www.google.com/imgres?h=2194&w=2560&tbnh=208&tbnw=243&osm=1&hcb=1&source=lens-native&usg=AI4_-kS6_BGTwSFj9yh4JZMIyL1U_VCYeg&imgurl=https://gtfoitsvegan.com/wp-content/uploads/2021/10/Thai-Style-Pad-Thai-Noodle-Bowl-by-Annie-Chuns-scaled.jpg&imgrefurl=https://gtfoitsvegan.com/product/thai-style-pad-thai-noodle-bowl-by-annie-chuns/&tbnid=ZsKHUQrMIjLJbM&docid=dCU5yjiovkfLAM&hcb=1",
"width":
243,
"height":
208
}
],
"offers":
[
{
"price":
"$30.99",
"link":
"https://puremodernliving.com/annie-chuns-noodle-bowls-case-of-6-8-1-oz/",
"source":
"puremodernliving.com",
"source_icon":
"https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRYohK0m3hr925v_amPaKkVemBOOohW2dMTEqeZXSV5LYyTpHMxZehF2AbNoMVWnj6zJaih5JXwO8_b3eT3MPjoFTClRMxiMbGxJblyA8wF9I3Ekvt-NyAfSQ"
},
{
"price":
"$3.19",
"link":
"https://www.target.com/p/annie-chun-39-s-vegan-noodle-bowl-korean-sweet-chili-8oz/-/A-15415186",
"source":
"target.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT0NBxJbjhPo7fICwO8po_ZW5pqh0MaK0k-HxaZx_CQiBFeb6PhctPRiZG-7YFbml47uEZPmZ016IktIlsLn58o0Cj7TwvwFDnnsGuimBQWi5Eyvw"
},
{
"price":
"$21.95",
"link":
"https://www.foodservicedirect.com/annie-chuns-pad-thai-noodle-bowl-8-1-ounce-6-per-case-1951692.html",
"source":
"foodservicedirect.com",
"source_icon":
"https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTiPt274gn68ohbVxb-PrExkz5a709eLtAa-WJ6g7IrdtHRZPyFSDwrbxgOXaURjdnmdJZ7d4g5PZEDaZxqEJwKKwFjhink14blped13na5u5jBYK7nojQSusQzwOUO"
}
]
}
],
"text_matches":
[
"a",
"Annie Chuns",
"PAD THAI",
"NOODLE BOWL"
],
"text_language":
"en",
"detected_objects":
[
{
"box":
{
"left":
0.4923077,
"top":
0.51692307,
"width":
0.59076923,
"height":
0.6830769
},
"detections":
[
{
"label":
"Annie Chun's Noodle Bowls - Case of 6 - 8.5 oz, Size: One Size",
"type":
"ROSTI",
"confidence":
87.18169
},
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
87.16168
},
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
87.21169
}
]
},
{
"box":
{
"left":
0.50461537,
"top":
0.58,
"width":
0.4553846,
"height":
0.28615385
},
"detections":
[
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
0.0002
},
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
0.0001
}
]
},
{
"box":
{
"left":
0.40887028,
"top":
0.4088235,
"width":
0.2646154,
"height":
0.083076924
},
"detections":
[
{
"label":
"Pad thai",
"type":
"GOLDMINE",
"confidence":
87.15168
}
]
},
{
"box":
{
"left":
0.489495,
"top":
0.2820546,
"width":
0.23384616,
"height":
0.06153846
},
"detections":
[
{
"label":
"Annie Chun's, Inc.",
"type":
"GOLDMINE",
"confidence":
74.22968
}
]
},
{
"box":
{
"left":
0.5952908,
"top":
0.38335586,
"width":
0.101538464,
"height":
0.033846155
},
"detections":
[
{
"label":
"Noodle",
"type":
"GOLDMINE",
"confidence":
80.812126
}
]
}
],
"searched_object":
{
"box":
{
"left":
0.4923077,
"top":
0.51692307,
"width":
0.59076923,
"height":
0.6830769
},
"detections":
[
{
"label":
"Annie Chun's Noodle Bowls - Case of 6 - 8.5 oz, Size: One Size",
"type":
"ROSTI",
"confidence":
87.18169
},
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
87.16168
},
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
87.21169
}
]
},
"reverse_image_search_link":
"https://www.google.com/search?tbs=sbi:AMhZZiu1KxdLEC8yZsbWLnmRHztvm4Y8yfMEP2gU6XdBk-TeNJtv1f_1a4sU7iEepobrFRttAEAHhACRIP27eRoRU7094ija97UqW_11yQma8vnTVLlzklMXXbI_1tD5Mdmj6tgGHTYgMkmpuMnJ748j778BO6G62SQvw"
}
},
{
"status":
"OK",
"request_id":
"d8739f52-d975-45d5-bbb6-13a3e9e7eeac",
"parameters":
{
"url":
"https://target.scene7.com/is/image/Target/GUEST_f2deab41-8424-4452-b09f-d22cc529401d?wid=325&hei=325&qlt=80&fmt=pjpeg",
"language":
"en",
"country":
"us"
},
"data":
{
"visual_matches":
[
{
"position":
1,
"title":
"SpaghettiOs Original Canned Pasta - 15.8oz",
"link":
"https://www.target.com/p/spaghettios-original-canned-pasta-15-8oz/-/A-17482486",
"source":
"target.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT0NBxJbjhPo7fICwO8po_ZW5pqh0MaK0k-HxaZx_CQiBFeb6PhctPRiZG-7YFbml47uEZPmZ016IktIlsLn58o0Cj7TwvwFDnnsGuimBQWi5Eyvw",
"thumbnail":
"https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSRrMGjvfj8_iG-vWF7MxPpwcPxcCieAFvdrUHZFqqjCEueRbJu",
"price":
"$1.39",
"availability":
"In stock",
"rating":
4.6,
"reviews":
18
},
{
"position":
2,
"title":
"SpaghettiOs® Original Canned Pasta, 15.8 OZ Can | Pasta & Noodles | Cannata's",
"link":
"https://www.cannatas.com/shop/pantry/pasta_and_pasta_sauce/pasta_and_noodles/spaghetti_os_original_canned_pasta_15_8_oz_can/p/6126230",
"source":
"cannatas.com",
"source_icon":
"https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRfShmMiHNoSs6XzUmxfUdOwL9N_8QADrKQHdJ-hjF4QP7vFbqawQylBHfu-dFjALEvcyP-FPoHnH8LUdOfEpkpEv5lmbV9Kpbxa8k21sWYGqOTGGA7",
"thumbnail":
"https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcSP0z_6HLqtgJ0L0ZRl15tHdE6PRN8va8SJaCnbvMkeqxDZa4Lv"
},
{
"position":
3,
"title":
"Campbells SpaghettiOs Pasta in Tomato and Cheese Sauce Original - 15.8 Oz",
"link":
"https://www.carrsqc.com/shop/product-details.960260859.html",
"source":
"carrsqc.com",
"source_icon":
"https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcS8Gxf2EaP-mZ8JHXuUt5ofT7UYoh3fJyUYm9ldfRZWXBW3FaLLolhUuaCJQcX5lP3N16AzLiwLNF1Nx6sl3i8lDKEgjkRUckko_tw6z43OH19g7kg",
"thumbnail":
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTXGOIObKuJauj4RxMc1XWaN9Q3Gsr6Gi6lZjGfwJNFrC8vCdrZ",
"price":
"$1.99",
"availability":
"In stock"
},
{
"position":
4,
"title":
"SpaghettiOs Pasta, Original",
"link":
"https://www.freshbybrookshires.com/sm/pickup/rsid/800/product/spaghettios-pasta-original-00051000232830",
"source":
"freshbybrookshires.com",
"source_icon":
"https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcQMH_WI_lGqVfY9ovaRHiFlsUKKleiSKUYQFZYNn-36_BMBzl2vOE69deWAUlDyxfvP4ST3ubz2Z4Hw2fhk41-9Q1qeyFbDPS4yGg3nCvThHyXw1ncD_ySMLk9fl5OJOw",
"thumbnail":
"https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTXekUtSNoDFg14zy1hL-HgIyeCz3oTfJleYw3X8np6sHD_IXrR"

],
"products":
[
{
"title":
"Campbell's SpaghettiOs Original Canned Pasta",
"link":
"https://www.google.com/search?q=Campbell%27s+SpaghettiOs+Original+Canned+Pasta&source=.lens.button&hl=en&gl=US",
"images":
[
{
"title":
"Image for Campbell's SpaghettiOs Original Canned Pasta",
"link":
"https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcRnn8MT1Kk-yWtlkdz0D5ycG_jfngVA5N1W_fMlATA6n_5c_v2Z",
"source":
"https://www.google.com/imgres?h=512&w=512&tbnh=225&tbnw=225&osm=1&hcb=1&source=lens-native&usg=AI4_-kQW3HMwbKmqGHAIaqN6_aX6Oq3VDw&imgurl=https://encrypted-tbn3.gstatic.com/images?q%3Dtbn:ANd9GcQD5HOsrQCNqyjsEKrhjjxi3EnNFuzjTdn9TBrek_jbat0B_cAf&imgrefurl=https://mypicks.bigy.com/departments/soup-and-canned-goods/campbell_s_spaghetti_os_original/p/6126230&tbnid=fyF5ABZeXf5NgM&docid=mBCUwrdKCxawjM&hcb=1",
"width":
225,
"height":
225
}
],
"offers":
[
{
"price":
"$1.99",
"link":
"https://www.carrsqc.com/shop/product-details.960260859.html",
"source":
"carrsqc.com",
"source_icon":
"https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcS8Gxf2EaP-mZ8JHXuUt5ofT7UYoh3fJyUYm9ldfRZWXBW3FaLLolhUuaCJQcX5lP3N16AzLiwLNF1Nx6sl3i8lDKEgjkRUckko_tw6z43OH19g7kg"
},
{
"price":
"$2.19",
"link":
"https://www.shopfamilyfare.com/shop/pantry/canned_goods/heat_and_serve_meals/campbell_s_original_canned_pasta_22_400_oz/p/542827",
"source":
"shopfamilyfare.com",
"source_icon":
"https://encrypted-tbn3.gstatic.com/favicon-tbn?q=tbn:ANd9GcSr69f4PKFIn6ms9acL3nVwAkkRVfUe0NdlY_HlH91-uLQ1t-V0-C7_JvWzSXE_oKtT0ZNU47B_K_sTGYBOoYr-k8W7pYA1IEV8NOO8LB7a6eBkQlcGpfxnmSch"
},
{
"price":
"$1.59",
"link":
"https://mypicks.bigy.com/departments/soup-and-canned-goods/campbell_s_spaghetti_os_original/p/6126230",
"source":
"bigy.com",
"source_icon":
"https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcRslSAYFbEvMk9j3w9acEZ_lI9y9Ize_ybEYYUOtRByJpD0dElCxTetTg0txT1CGqL2zjduw0WzRfeDSTN4e7iUwKkuRi7-Z5VDPtf_7Zxv90dS_TGD"
}
]
}
],
"text_matches":
[
"Campbell's",
"SPAGHETTIOS ORIGINAL",
"PASTA IN TOMATO AND CHEESE SAUCE 4"
],
"text_language":
"en",
"detected_objects":
[
{
"box":
{
"left":
0.4992829,
"top":
0.499443,
"width":
0.6769231,
"height":
1
},
"detections":
[
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
79.00971
},
{
"label":
"Spaghettios Original Can",
"type":
"ROSTI",
"confidence":
78.98971
},
{
"label":
"SpaghettiOs Original",
"type":
"FRYWOK",
"confidence":
78.9697
},
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
78.9597
}
]
},
{
"box":
{
"left":
0.49399462,
"top":
0.27678236,
"width":
0.48,
"height":
0.13538462
},
"detections":
[
{
"label":
"SpaghettiOs",
"type":
"GOLDMINE",
"confidence":
78.9497
}
]
},
{
"box":
{
"left":
0.48923078,
"top":
0.74153847,
"width":
0.30153847,
"height":
0.20307693
},
"detections":
[
{
"label":
"SpaghettiOs Original",
"type":
"FRYWOK",
"confidence":
78.9697
},
{
"label":
"Unknown Type",
"type":
"UNKNOWN",
"confidence":
0.0001
}
]
}
],
"reverse_image_search_link":
"https://www.google.com/search?tbs=sbi:AMhZZisVNOCnochS-u4GXxLdN3vL1KP5ljwO51fQJSP83fRzwwu6f4ZOS75Uy7SDP-a6As5eYKH_1AkGyu5GEmcDt20sZe1qO_1mItMw7gd3rbYPvOZfgBcku44srphnsBIe9ihDWojZk8aPcYHXmDplusRPe14z0Znw"
}
}
}
}
]

I aplogize for the length of this post, etc. as I did not know how to attach a file.

In the n8n code node I am trying to parse the output of the HTTP Request node. I am trying to parse the url, all the positions (including title, link, source, source_link, thumbnail, price, availability, rating, and reviews) from visual_matches, and the reverse_image_search_link. Then I want to save the parsed data to a spreadsheet file and write the file to my HDD.

I hope that makes sense.

Thank you for any and all comments, suggestions, etc.

Frank Gunseor

13

Hi @fdavidg, thanks so much for sharing this example output. Is there a chance this is formatted output rather than the raw JSON data?

You can copy the original data structure from a node by selecting the JSON view in n8n, then the first row of data and lastly use the Copy button → Copy Selection like so:

image
image748×895 84.3 KB

This will help greatly with understanding your data structure, which right now doesn’t completely seem to match your code. Once we’ve sorted out the exact structure we can take a look at how to write the results into decent spreadsheet files :slight_smile:

With regards to you workflow including the Split in Batches loop:

I see you’re connecting the branch including googleLensResults Spreadsheet File node to the looping part. Do you want multiple spreadsheet files? Or rather just one result file (in which case you’d want to only use the “Done” branch for your file).

14

Good morning,

First, thank you so very much for all your help in learning the ins and outs of n8n. It is a truly awesome tool!

Here is the output requested after following your instructions (hopefully correctly(:slight_smile: ):

[
  {
    "status": "OK",
    "request_id": "9d3c6279-663a-4b04-b55a-abcb7be4a7d5",
    "parameters": {
      "url": "https://target.scene7.com/is/image/Target/GUEST_8754939d-d28e-4647-a7c2-fe4e730bf314?wid=325&hei=325&qlt=80&fmt=pjpeg",
      "language": "en",
      "country": "us"
    },
    "data": {
      "visual_matches": [
        {
          "position": 1,
          "title": "Tender Noodles, Signature Flavors | Annie Chun's Noodle Bowls",
          "link": "https://anniechun.com/products/noodle-bowls/",
          "source": "anniechun.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcSVJVky3wCJajbUfPmT1UvmgShshLYSEZEgkqAmrpGyHfg38vdmqFwVD6liH3kAk8JU6g1cYnYc1X-190end9LjZr4Kb_LLPVIj0MZGGRdIufjJ",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcQwKoT-WmNoHHK58O5zz7OTQfRz5elHLGwVxesbgJLUOSQD-oDN"
        },
        {
          "position": 2,
          "title": "Annie Chun's Noodle Bowl Pad Thai Vegan - 8.1 oz pkg | Stop & Shop",
          "link": "https://stopandshop.com/product/172218/?source=static-page",
          "source": "stopandshop.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTt7Gh0GLt1rqboofYu4j3l2D5IqB4C-he98u6jzpjy8ufsV09tdyzC825mgl8vSU-lBzx0DVM81mKf2oINydJZZzzwFytlFLb77UCYj8BaLEMD4Yw",
          "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSVUZfl9mv5PoPgWe3CdKTO4jd1_dTP83PfBUbsTcGEyTQqFS_Z"
        },
        {
          "position": 3,
          "title": "Annie Chun's Vegan Noodle Bowl Pad Thai - 8.1oz",
          "link": "https://www.target.com/p/annie-chun-39-s-vegan-noodle-bowl-pad-thai-8-1oz/-/A-15415187",
          "source": "target.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT0NBxJbjhPo7fICwO8po_ZW5pqh0MaK0k-HxaZx_CQiBFeb6PhctPRiZG-7YFbml47uEZPmZ016IktIlsLn58o0Cj7TwvwFDnnsGuimBQWi5Eyvw",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcRAmMnE9vlcfUCGoGxVnEPnEOuT_EEn6NnnErmsiFjU5N7A6cfi",
          "price": "$3.19",
          "availability": "In stock"
        },
        {
          "position": 4,
          "title": "Annie Chun's Noodle Bowls - Case Of 6 - 8.1 Oz",
          "link": "https://puremodernliving.com/annie-chuns-noodle-bowls-case-of-6-8-1-oz/",
          "source": "puremodernliving.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRYohK0m3hr925v_amPaKkVemBOOohW2dMTEqeZXSV5LYyTpHMxZehF2AbNoMVWnj6zJaih5JXwO8_b3eT3MPjoFTClRMxiMbGxJblyA8wF9I3Ekvt-NyAfSQ",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcSfhCf0BaauRtQOsu_9s_2Q3vRtD0a0NCl0j54r55B7ftLi6cwg",
          "price": "$32.99",
          "availability": "In stock"
        },
        {
          "position": 5,
          "title": "Annie Chun's Noodle Bowl, Thai-style Pad Thai, Vegan, Non Gmo Project",
          "link": "https://www.ebay.com/itm/175683234647",
          "source": "ebay.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT5NXsW5qpQoNKtvnEC0sNL88H54opWmBBYIh2gQ3U_SGUU-yc8xV_BfeECVq4HYfwroQsx3k4lpMvjDByZM4KvONyK63j7aI6RPQrDFwRa9lo",
          "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRXeeiYeoVlRdjg5c6tLX_tnfr43LsvRk__p2hss3_NDr0K4lni",
          "price": "$28.72",
          "availability": "In stock"
        },
        {
          "position": 6,
          "title": "Packaged Asian Meals - Order Online & Save | Stop & Shop",
          "link": "https://stopandshop.com/groceries/rice-grains-pasta-beans/packaged-meals-sides/packaged-asian-meals.html",
          "source": "stopandshop.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTt7Gh0GLt1rqboofYu4j3l2D5IqB4C-he98u6jzpjy8ufsV09tdyzC825mgl8vSU-lBzx0DVM81mKf2oINydJZZzzwFytlFLb77UCYj8BaLEMD4Yw",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcRs8i_L70rVB1UOpgojW3BDL9xxZc_Gui9ynrJtAgfWIup0_YvF"
        },
        {
          "position": 7,
          "title": "Annie Chun's Noodle Bowl, Pad Thai, Thai-Style",
          "link": "https://www.freshbybrookshires.com/product/annie-chuns-noodle-bowl-pad-thai-thaistyle-00765667100806",
          "source": "freshbybrookshires.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcQMH_WI_lGqVfY9ovaRHiFlsUKKleiSKUYQFZYNn-36_BMBzl2vOE69deWAUlDyxfvP4ST3ubz2Z4Hw2fhk41-9Q1qeyFbDPS4yGg3nCvThHyXw1ncD_ySMLk9fl5OJOw",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcTZVwPIwrAk523MP4gRQkcrGZ4tJcSf06osiVPdHHKJIuMX_254"
        },
        {
          "position": 8,
          "title": "Pad Thai Noodle Bowl, 8.1 oz at Whole Foods Market",
          "link": "https://www.wholefoodsmarket.com/product/annie-chuns-pad-thai-noodle-bowl-81-oz-b000wcybl0",
          "source": "wholefoodsmarket.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcR9zWC-AOzImC-QNmo56NYAe_9HKBATgy8VJsfM4WGt1MD2q8PsnzSWqL2cFF1Q-COE03PmF31Uuw3DY5EgfqjYxBoowx0orTBi_XGnoLI9wknZUtQhf8t7lhKKs2g",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcRJLxpssSKdQcj3zYBlSkt7BrsouulZxK2LEPAftO-nvqcps0q8"
        },
        {
          "position": 9,
          "title": "Annie Chun's Noodle Bowls - Case of 6 - 8.1 OZ, 8.1 OZ - Kroger",
          "link": "https://www.kroger.com/p/annie-chun-s-noodle-bowls-case-of-6-8-1-oz/1076566710080",
          "source": "kroger.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcTT75GJwlN-aLUTLgU1MLWiLNmUlufvz8Fs82dHBoWwerye7mGKYkshDGTtacmJC9NB8IO7CZXpCtpvYcGkioZ0ELKJT7uckBgAF5g1znQBdofOEQ",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcS-98hGP4ZPdDJZ97tvCEFaCmxuJF6jiKluPdmtFNMb-_2x3OR9"
        },
        {
          "position": 10,
          "title": "Annie Chun's® Thai-Style Pad Thai Noodle Bowl, 8.1 oz - Kroger",
          "link": "https://www.kroger.com/p/annie-chun-s-thai-style-pad-thai-noodle-bowl/0076566710080",
          "source": "kroger.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcTT75GJwlN-aLUTLgU1MLWiLNmUlufvz8Fs82dHBoWwerye7mGKYkshDGTtacmJC9NB8IO7CZXpCtpvYcGkioZ0ELKJT7uckBgAF5g1znQBdofOEQ",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcSOD1OV0hWHccY59BAVRmvjHRm5QPbHL7HyMEIltwRmBm_BgNLV"
        },
        {
          "position": 11,
          "title": "Amazon.com : Annie Chuns Pad Thai Noodle Bowl, 8.1 Ounce -- 6 per case : Grocery & Gourmet Food",
          "link": "https://www.amazon.com/Annie-Chuns-Thai-Noodle-Ounce/dp/B08RHGL35D",
          "source": "amazon.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRm4oMDPHDSWBDQhB5-csYIdmVde_ZfnfUYnfzlJJ9w7zjXG34H4SL9TXI2H8XWInsqPagyhBQjtImrHgLv9Bwvw_d2JvfjMfz3ox9yR82MKQ7yrQ",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcRpphsHoxIrH7tYIA365N-5seN9OwCoyv1cYU8-x1AZqyc2qOX7"
        },
        {
          "position": 12,
          "title": "Annie Chun's Noodle Bowl, Pad Thai, Thai Style 8.1 Oz",
          "link": "https://www.shopdwfreshmarket.com/shop/pantry/packaged_meals/annie_chun_s_noodle_bowl_pad_thai_thai_style_8_1_oz/p/56359",
          "source": "shopdwfreshmarket.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTTUoxvLZBDlGRxqfResgEUGN8AISLgJ6He5e3EIp7Xq2WdBvJbm7nVG56b37zUh1gT8s791Kwj_49Z3ub_4DhZrYh6v2PQyMNSIHT3p0u503UfNfpLRid3-2tQsL0l",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcQOCseOcmaIG7pSvldZvQHJTWz18Y26zSEvvz1na6wC98MHHoI4",
          "price": "$3.99"
        },
        {
          "position": 13,
          "title": "Annie Chuns Pad Thai Noodle Bowl, 8.1 Ounce -- 6 per case",
          "link": "https://www.foodservicedirect.com/annie-chuns-pad-thai-noodle-bowl-8-1-ounce-6-per-case-1951692.html",
          "source": "foodservicedirect.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTiPt274gn68ohbVxb-PrExkz5a709eLtAa-WJ6g7IrdtHRZPyFSDwrbxgOXaURjdnmdJZ7d4g5PZEDaZxqEJwKKwFjhink14blped13na5u5jBYK7nojQSusQzwOUO",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSDwl9d-4Wsh25DpC8GMww_pIZNBwnFRpU0er8UlBlXd1Adl6F4",
          "price": "$21.95",
          "availability": "In stock"
        },
        {
          "position": 14,
          "title": "Annie Chun's Vegan Noodle Bowl Korean Sweet Chili - 8oz",
          "link": "https://www.target.com/p/annie-chun-39-s-vegan-noodle-bowl-korean-sweet-chili-8oz/-/A-15415186",
          "source": "target.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT0NBxJbjhPo7fICwO8po_ZW5pqh0MaK0k-HxaZx_CQiBFeb6PhctPRiZG-7YFbml47uEZPmZ016IktIlsLn58o0Cj7TwvwFDnnsGuimBQWi5Eyvw",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcSCoIGYCbQBXUvxHDmqRAkyJjhKBEh2lkRWQJ8DebD6oQ9Zj1kq",
          "price": "$3.19",
          "availability": "In stock",
          "rating": 4.2,
          "reviews": 31
        },
        {
          "position": 15,
          "title": "Thai Style Pad Thai Noodle Bowl by Annie Chuns",
          "link": "https://gtfoitsvegan.com/product/thai-style-pad-thai-noodle-bowl-by-annie-chuns/",
          "source": "gtfoitsvegan.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcRZrYVhOjlxG3NofZ-MBszRTCzi9K3L6pTAWxSfo5YgOg8Ya2d_0h7otd42V5qPKWojvdtGkEGGE_P3LUybEigRkZFsIaDirtaJJUR7PqmlDJ-UXNH2",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcS_iTpyjGkhLR0p90P950bm3ZIdzdbOJ7QugyunWpiFboI_2rHE",
          "price": "$5.29"
        },
        {
          "position": 16,
          "title": "Annie Chun's Pad Thai Noodle Bowl 8.1 Oz (pack Of 5) Vegan",
          "link": "https://www.ebay.com/itm/353086828947",
          "source": "ebay.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT5NXsW5qpQoNKtvnEC0sNL88H54opWmBBYIh2gQ3U_SGUU-yc8xV_BfeECVq4HYfwroQsx3k4lpMvjDByZM4KvONyK63j7aI6RPQrDFwRa9lo",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcTdC4VBniuDD01HL4gQbYZ8pXLbsVc3Z1BAxUStlf5DttuOT2bI",
          "price": "$22.00",
          "availability": "In stock",
          "rating": 4.7,
          "reviews": 3
        },
        {
          "position": 17,
          "title": "Annie Chun's Noodle Bowls - Case of 6 - 8.1 OZ, 8.1 OZ",
          "link": "https://www.smithsfoodanddrug.com/p/annie-chun-s-noodle-bowls-case-of-6-8-1-oz/1076566710080",
          "source": "smithsfoodanddrug.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTkRGIZpbeoYJn7WxSv0uaBAjg5HWP7w6beTjn8cyhht7okAeik4rdTrp8BTcn-ZIXSFE2bCe40_C7HSWny6SndWQLQPQJxAL4Dzpjm3IzHbPnup7CUsE7493_EKUdq",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcRf5esISQthvYRmEJv93Erzn4Ukw3WZ2lBPrOlqY6NDRj5NvDG4",
          "price": "$38.60"
        },
        {
          "position": 18,
          "title": "Annie Chun's Pad Thai Noodle Bowl - 8.4 oz | CVS",
          "link": "https://www.cvs.com/shop/annie-chun-s-pad-thai-noodle-bowl-prodid-2330057",
          "source": "cvs.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcQBKiR4RgnVgaY3dwUuZ_WCS41Ftroy6lIov1I-YWJS69srw-QBjfc0tXi7QJDMb0Cm9HGmTaGTokswoaIItvaxV58ucxuFAPigSz9gzmIecg",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcTfD1ouiHXZdBlQi1i_gKGavP3gq_e-f4EVSVOhRs69di70GObw",
          "price": "$4.99",
          "availability": "In stock"
        },
        {
          "position": 19,
          "title": "Annie Chun's Noodle Bowl, Pad Thai, Thai-Style",
          "link": "https://www.cub.com/product/annie-chuns-noddle-bowl-pad-thai-thaistyle-00765667100806",
          "source": "cub.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTXlinY5UoHIHZuUnqO1Sze9BgeokDJKx60UsaYcRiJyT9HVVTYtBFIwvjqAaaJp2gcKcYn0lRnR4I1ILwCqT0OWi-jG_qHemEUeImKF9IP_Q",
          "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQlk7FFZ6tTOSeP04HjbobH01VS5pPI-hUIBk41_vKNyNsN8p_l",
          "price": "$4.79",
          "availability": "In stock"
        },
        {
          "position": 20,
          "title": "Annie Chun's Noodle Bowls 8.1 oz - Pack of 6 | eBay",
          "link": "https://www.ebay.com/itm/266092126402",
          "source": "ebay.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT5NXsW5qpQoNKtvnEC0sNL88H54opWmBBYIh2gQ3U_SGUU-yc8xV_BfeECVq4HYfwroQsx3k4lpMvjDByZM4KvONyK63j7aI6RPQrDFwRa9lo",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcQYhE8zhT0jBQudSy3AmlY5YzaOruGnZ4I5EzGICBOhgkjRXCag"
        },
        {
          "position": 21,
          "title": "Annie Chun's Noodle Bowls - Pad Thai - 8.1 oz",
          "link": "https://shop.jennyhoople.com/products/annie-chuns-noodle-bowls-pad-thai-8-1-oz",
          "source": "jennyhoople.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcQvAtNlujPw0sPy5Psi1NGD9l17oUwwUhKzKBBQ3yUPOCBTr0Ujh7TVeo3X5SXcp44TtLLhdRsTXNVhLm-SLkPgoUAt_DdRc_K5CziIgQLw2hapPcljkNqlig",
          "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTmRpWpxHYwrE8aziOBBQtaD-rleIfILqYOWxTJzdiDLStMzrJd",
          "price": "$5.35"
        },
        {
          "position": 22,
          "title": "Annie Chun's Thai-Style Pad Thai Noodle Bowl 8.1 oz | Northgate Market",
          "link": "https://www.northgatepronto.com/shop/annie_chun_s_thai_style_pad_thai_noodle_bowl_8_1_oz/p/56359",
          "source": "northgatepronto.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcQdmEfe3AsJc1KfLGvae0Bp2c842D25gcc_YlNaN07DHSRKL8LZexQM3sqy6HesRgmSmL5GaQbXDvy9WskaNmVFlx-GBbsxtQPwqxRuq7EjcOCqkjvDf2lxrwb_GA",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcRWKueSnSAVTRouxzcigdEJk6pvXssEmDYBWi002xwJgkBpYP2H"
        },
        {
          "position": 23,
          "title": "Annie Chun's Thai-style Pad Thai Noodle Bowl Packaged Meal, Shelf",
          "link": "https://www.ebay.com/itm/155587021278",
          "source": "ebay.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT5NXsW5qpQoNKtvnEC0sNL88H54opWmBBYIh2gQ3U_SGUU-yc8xV_BfeECVq4HYfwroQsx3k4lpMvjDByZM4KvONyK63j7aI6RPQrDFwRa9lo",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcRYDYWDt1G-sym-ZJYfGe-0wpYy4fBKu0jvnX7gKvgbOYYyTTxK",
          "price": "$6.99",
          "availability": "In stock"
        },
        {
          "position": 24,
          "title": "Annie Chun's Pad Thai Noodle Bowl",
          "link": "https://veganessentials.com/products/annie-chun-s-pad-thai-noodle-bowl",
          "source": "veganessentials.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcQj5E2EpH0eJOz_S0ORHiOUJJlWrwWapjxaR74BaRvfH7V_BNexxF7bRDoMNIdE4c45I3nYMgKqNfdKcIzcKrud9Pnn-FEZCd2GvvM2YBEz6BZzj1KUD5sp",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTHIkdkN1y2XplT9-F65cIEjDxWIph1-Jp7cAf62erMwVWc8ntg",
          "price": "$6.49"
        },
        {
          "position": 25,
          "title": "ANNIE CHUN'S Thai Style Pad Thai Noodle Bowl",
          "link": "https://elmcitymarketdelivers.com/annie-chuns-thai-style-pad-thai-noodle-bowl/",
          "source": "elmcitymarketdelivers.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRhHx49Wsbl6JtYS2_JPWIyfC6yvbwrz2SAuKj1QYgQit9ejRiCMLcJdKGlbZMzRAmfhHUfaWhc1ICz_YQaWZ9ro5OMAsByYiMLqQDDPOsEhZts6kH2MFFuB-p3lerG",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcRdd64d2DZ3aYizpORjFx8jUTVWJJWaxxY-WZlpudeI5kfYs2D-",
          "price": "$4.49",
          "availability": "In stock"
        },
        {
          "position": 26,
          "title": "Soups products delivery in Denver, CO | Pinemelon.com",
          "link": "https://pinemelon.com/en/denver/catalog/cat/40501-soups",
          "source": "pinemelon.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcTiXTjq18sxi3-GDi6GZFKo_iSzlDE6L823tI_lr3lCQXiwG0Rj4Dl63O2-GicuwLlxFdcfL7HVEqK18AkSPSKj_gy8XJ3ZV3dDaFz97vsM0G7q",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcRpREGLOs_Y7Ru4ZoaR4yuDolU7PnDYbL73aA77L4iRbETpZher"
        },
        {
          "position": 27,
          "title": "Annie Chun's Vietnamese-Style Pho Soup Bowl Vegan - 5.9 oz pkg | Stop & Shop",
          "link": "https://stopandshop.com/product/231770/?source=static-page",
          "source": "stopandshop.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTt7Gh0GLt1rqboofYu4j3l2D5IqB4C-he98u6jzpjy8ufsV09tdyzC825mgl8vSU-lBzx0DVM81mKf2oINydJZZzzwFytlFLb77UCYj8BaLEMD4Yw",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTpV3_Nz_uFEU6XV1REkd5YXE45jIoYlwuJHLbmTN04aNdAqVCY"
        },
        {
          "position": 28,
          "title": "Annie Chun's Asian Style Noodle Soup Bowls",
          "link": "https://www.ebay.com/itm/303611535809",
          "source": "ebay.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT5NXsW5qpQoNKtvnEC0sNL88H54opWmBBYIh2gQ3U_SGUU-yc8xV_BfeECVq4HYfwroQsx3k4lpMvjDByZM4KvONyK63j7aI6RPQrDFwRa9lo",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcSKsqwyKH_Dzrj3RucqqsPu2REtMY1d4Fi8wdCkozzGnCUzG67R",
          "price": "$9.95",
          "availability": "In stock"
        },
        {
          "position": 29,
          "title": "Annie Chun's Noodle Bowl, Teriyaki, Non-GMO, Vegan, 7.8 Ounce",
          "link": "https://www.amazon.com/Annie-Chuns-Noodle-Teriyaki-Non-GMO/dp/B01B630QFS",
          "source": "amazon.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRm4oMDPHDSWBDQhB5-csYIdmVde_ZfnfUYnfzlJJ9w7zjXG34H4SL9TXI2H8XWInsqPagyhBQjtImrHgLv9Bwvw_d2JvfjMfz3ox9yR82MKQ7yrQ",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcRP5yLGb2ANjTyZoCuKXap2D68lwAajwCvokPz39gaBn13jYW4x",
          "price": "$7.59",
          "rating": 4.5,
          "reviews": 14
        },
        {
          "position": 30,
          "title": "Daiya Gluten Free And Vegan Cheezy Mac Meatless Bac'n & Cheddar Style -10.9oz : Target",
          "link": "https://www.target.com/p/daiya-gluten-free-and-vegan-cheezy-mac-meatless-bac-39-n-38-cheddar-style-10-9oz/-/A-82304390",
          "source": "target.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT0NBxJbjhPo7fICwO8po_ZW5pqh0MaK0k-HxaZx_CQiBFeb6PhctPRiZG-7YFbml47uEZPmZ016IktIlsLn58o0Cj7TwvwFDnnsGuimBQWi5Eyvw",
          "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQjjBipZugNTnmYaQ_ZFC3wKP9-QfSjGeW-aS4epPHVaSMNJIw0"
        },
        {
          "position": 31,
          "title": "Annie Chun's Noodle Bowls - Case Of 6 - 8.7 Oz",
          "link": "https://www.organikthings.com/products/annie-chun-s-noodle-bowls-case-of-6-8-7-oz",
          "source": "organikthings.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcSUbh0kurfF0q3mul1bKC1kQZrlTfb-HnFoZhjPLwe5mzrcefaeyIKiWJW6uaYaW850CrJX4pKwr1sZHoKD_owZFUYKjTpAIr49zwHhYmaVdZBhXxbcKVrsrb4",
          "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTaZ5aUfDRtJTpgOycbE9F5d5PBDzm_ik559MUEyERhFAYtE1QN",
          "price": "$29.10"
        },
        {
          "position": 32,
          "title": "Thai Kitchen Pad Thai Noodle Kit 9 oz – California Ranch Market",
          "link": "https://californiaranchmarket.com/products/thai-kitchen-pad-thai-noodle-kit-9-oz",
          "source": "californiaranchmarket.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcSkdADrTI2gM3pR86WTedOUQO9TDioE6AuDE0o1tRA87zVQZNpo5Fhf87xwewarnGI8qe4zKAgXTWvlciXYzrOCCRF76Q1rLQyv9faQIyA1mZJG21mDShxJsmgzS-Um",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcRDJGClmuNTDpc4342BiJYJnlGwpy4uvSmLw2nCzVTzK6Cj7sAT"
        },
        {
          "position": 33,
          "title": "Annie Chuns Annie Chun's Vegan Noodle Bowl Pad Thai - 8.1oz",
          "link": "https://www.shipt.com/up/annie-chuns-annie-chuns-vegan-noodle-bowl-pad-thai---81oz/bf8affed-786f-2a0a-8764-ccf06f519bcc?zip=60148",
          "source": "shipt.com",
          "source_icon": "https://encrypted-tbn3.gstatic.com/favicon-tbn?q=tbn:ANd9GcQGwTfYWm-tbQkomgNFWKsaSSeNCHN847Hyu7a5rHrVkSpJW-ojGNt1XJAl661EP1x1kK9baOWpSWyQxb1GjBBBIcK163aAHP9_PC3FUJc8RL4Z",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSXfJtiaqWqLvnLgMpL1X9bxKhCZ42mzXasqjH8IDdRDJFtCNjT",
          "price": "$3.19"
        },
        {
          "position": 34,
          "title": "Thai Kitchen Coconut Cream Unsweetened 12.66 oz – California Ranch Market",
          "link": "https://californiaranchmarket.com/products/thai-kitchen-coconut-cream-unsweetened-12-66-oz",
          "source": "californiaranchmarket.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcSkdADrTI2gM3pR86WTedOUQO9TDioE6AuDE0o1tRA87zVQZNpo5Fhf87xwewarnGI8qe4zKAgXTWvlciXYzrOCCRF76Q1rLQyv9faQIyA1mZJG21mDShxJsmgzS-Um",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcQ8GNA4hJ9sHdwsCWagyBFkbzWuwvti78w_I-HHAhh8JfCDlJOB"
        },
        {
          "position": 35,
          "title": "Annie Chun's Pad Thai Brown Rice Noodles, Non Gmo, Vegan, Gluten Free,",
          "link": "https://www.ebay.com/itm/325669123606",
          "source": "ebay.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT5NXsW5qpQoNKtvnEC0sNL88H54opWmBBYIh2gQ3U_SGUU-yc8xV_BfeECVq4HYfwroQsx3k4lpMvjDByZM4KvONyK63j7aI6RPQrDFwRa9lo",
          "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSSdIHwH669_YptzbDUlQzg_17mHNxrk8Dkv5XBrBW6TXpWVyIz",
          "price": "$37.99",
          "availability": "In stock"
        },
        {
          "position": 36,
          "title": "Annie Chun's Annie Chun's Udon Noodles Soup Bowl 6/5.9 Oz. | Round Eye Supply",
          "link": "https://roundeyesupply.com/products/annie-chuns-udon-noodles-soup-bowl-6-5-9-oz-734890",
          "source": "roundeyesupply.com",
          "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcR6ChHeAKDQSpHiy-DMcRxk1Ag_2S4a5yM6yXUUYHYB1SxDjsZTD4ajz3kQCpKS-OzPsMYi29JAz4G0PpLVX-f_mek-ltm4qThXZqnyO6ijCFU7aHSJu6c",
          "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcRx3DG_t2wIiqqMEI9uE54oF6f1_nAju7LD1PQIWzQH1LCDx9Ul"
        },
        {
          "position": 37,
          "title": "Amazon.com : Annie Chun's Pad Thai Rice Noodles, Non GMO, Vegan, Gluten Free, 8 Oz (Pack of 6) : Annie Chun Brown Rice : Everything Else",
          "link": "https://www.amazon.com/Annie-Chuns-Gluten-Free-Noodles-Vegan/dp/B000E18CS2",
          "source": "amazon.com",
          "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcRm4oMDPHDSWBDQhB5-csYIdmVde_ZfnfUYnfzlJJ9w7zjXG34H4SL9TXI2H8XWInsqPagyhBQjtImrHgLv9Bwvw_d2JvfjMfz3ox9yR82MKQ7yrQ",
          "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcTAU0pU-DHrmGqXeUt0dDKIM7xjr8KJoga7Q1Q_9XkynYNpbB1Z"
        },
        {
          "position": 38,
          "title": "Annie Chun's Brown Rice Noodles, Pad Thai | Vegan, 8-oz (pack Of 6) |",
          "link": "https://www.ebay.com/itm/175690251393",
          "source": "ebay.com",
          "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcT5NXsW5qpQoNKtvnEC0sNL88H54opWmBBYIh2gQ3U_SGUU-yc8xV_BfeECVq4HYfwroQsx3k4lpMvjDByZM4KvONyK63j7aI6RPQrDFwRa9lo",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcS_X-_FQjIcSYxNzU4sdYaEKz3_IOXb7bz7L9rU2_L1GBJ0sUJR",
          "price": "$37.99",
          "availability": "In stock",
          "rating": 4.6,
          "reviews": 234
        },
        {
          "position": 39,
          "title": "Pad Thai Brown Rice Noodles - 8 oz | Annie Chun's",
          "link": "https://veganblackmarket.com/products/annie-chuns-pad-thai-brown-rice-noodles-8-oz",
          "source": "veganblackmarket.com",
          "source_icon": "https://encrypted-tbn3.gstatic.com/favicon-tbn?q=tbn:ANd9GcQyXPhZzpLqRmYLI1c9ldltUjzmZxXnRrTP0afVO89_BUYB7rrdnPjydtiD0IwfnJoG6Vt9ENqs_NxC46aSg2tZAytlgEIWlqzHsbhAEQR_5XnDJDd04FEUlQ",
          "thumbnail": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcSw_hrCBs9_06ZTmicXObVo-5qPjwGitg_f9t415k0xFNbrlHD6",
          "price": "$4.39",
          "availability": "In stock"
        }
        
      ],
      "products": [
        
          ],
          "offers": [
            
          ]
        }
      ],
      "text_matches": [
        
          ]
            
        ]
      },
      "reverse_image_search_link": "https://www.google.com/search?tbs=sbi:AMhZZival75ss7pZMmBFzufXcI2mdpSYXnSgIpHXtybs8p7Of6XAjv9lyS926btLfyjeqKRqOQEYfccW2Wfh-XrngnlLGvl3I-pzGWfnHawEeZ_1Q-dqtwuXWfRNSowovoN9SLtLZJgzxYGOlPNscA-uONVMHgsYPcA"
    }
  }
]

NOTE: I had to significantly truncate the file to get it to fit!

As to the Split In Batches loop; I was using that loop to begin with (learning n8n) mainly to see what was going on and to help me learn the differences in output. It will go away in the final “production” workflow!

Thannk you very much!

Frank

15

MutedJam,

Here is the example output from the API (I had to cut it in half because of the 32000 character limit in the Body) I removed Position 7 - Position 59:

{
  "status": "OK",
  "request_id": "960e69ee-4cb9-4095-847c-a1e4161a9c37",
  "parameters": {
    "url": "https://i.imgur.com/HBrB8p0.png",
    "language": "en"
  },
  "data": {
    "visual_matches": [
      {
        "position": 1,
        "title": "File:Danny DeVito by Gage Skidmore.jpg - Wikipedia",
        "link": "https://en.wikipedia.org/wiki/File:Danny_DeVito_by_Gage_Skidmore.jpg",
        "source": "wikipedia.org",
        "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcRLIcgPlYxOaoBg0MnSobLYyflrgF_RLdwAY09AXHWGy2jqWQnuIBNCY5I1BuzY7jeAJga0y0b9htBHe94i3Pg4B0NhHMNDVsmS-FVRKL014d-Xf6sX",
        "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcS_EZZflK6_1HccjH6c-eZbcBIqmW7CZi1EL6Nfjm-2iiJoE6Am"
      },
      {
        "position": 2,
        "title": "Signature — Kyle Darnell",
        "link": "http://kyledarnell.squarespace.com/signature",
        "source": "squarespace.com",
        "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcQDxQKmyfsEPuw-zIQoRhGeXNAVAII-0uRuvYGVg-qjGsf4rxAaGQ3IrdVR2_t6-4cjQiZksN6PAeEbXLnbrBvZxDgQ7uKJyAHA-vxTpdfzZSwzcd8r_ajKoPWHNUHDNw",
        "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTkclKTtAuG3t5BXrkj3mDTOZspqS318nej5FilfebqtiOBfO5c"
      },
      {
        "position": 3,
        "title": "Philly DSA 🌹 on Twitter: \"A rare color photo of Amadeo Bordiga. The only Left Communist we trust tbh https://t.co/LZlle7RX3n\" / Twitter",
        "link": "https://twitter.com/PhillyDSA/status/877490818038329344",
        "source": "twitter.com",
        "source_icon": "https://encrypted-tbn0.gstatic.com/favicon-tbn?q=tbn:ANd9GcTobhbt0ZKwS5VFQSzydvQt8vjhhiwervtw9rdJdbWu12RMXaoRjkTltT0aoTWQ6_jjnhnlkM8mMaX4wNSw065V_4Iu62Ljd402sY56ddVX_w",
        "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcRXRdHrAm2Ojzv5oaqI2XSex_BKJ9SOw0zDgF0vibcP87nUzl8i"
      },
      {
        "position": 4,
        "title": "Danny DeVito doesn’t want your free Champagne | Page Six",
        "link": "https://pagesix.com/2015/08/04/danny-devito-doesnt-want-your-free-champagne/",
        "source": "pagesix.com",
        "source_icon": "https://encrypted-tbn1.gstatic.com/favicon-tbn?q=tbn:ANd9GcQ5VOQL9qc4byqDxWSoWpvuIWO8FL7JsnD-qppPxL4JXnSA5SbpnmIFOBOsu6c3XEF8eP5HqNfU1bMh_2np33RDmGu2NnB_RiqRNAnGAVQhAQ",
        "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcRHXdVUfAAp8FFxQRhW0-tvaTOxwLBjLPPfwLci9eoJClzv048C"
      },
      {
        "position": 5,
        "title": "Danny DeVito - IMDb",
        "link": "https://www.imdb.com/name/nm0000362/",
        "source": "imdb.com",
        "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcTFehdJYsJGaKRE9UV-IK0kaOc0dNWXVGr3XLPVFUGvc-sssumlm-DVVWDCahNCXEbCcS9XnW6yhTAYAjfCH8kiJvjjmg2R3XCq5d_cl1CJe0c",
        "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcSIcUzlP7TtHIMWozhyjVbbdU5WmnLm5-ekqEJnSbPxSIk3NlmA"
      },
      {
        "position": 6,
        "title": "Danny DeVito | Disney Fanon Wiki | Fandom",
        "link": "https://disneyfanon.fandom.com/wiki/Danny_DeVito",
        "source": "fandom.com",
        "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcRpcimHLrZ9XlZScz0BKgTnI8am1mRwWtCy9SdiXy--yUsePMEdUAOi63PR4wb3EjDTptVEeBtvHghqtAUJ_-mE8YONcChsl5eIOBOJBhLaA845Zf7BJrJd1VCW",
        "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcSsag6m4RSPUujsZus7UarZd-hV4Xw5FZ2PKRX9p4swuFcfC5aT"
      },
      {
        "position": 60,
        "title": "See the Cast of 'Twins' Then and Now",
        "link": "https://screencrush.com/twins-then-and-now/",
        "source": "screencrush.com",
        "source_icon": "https://encrypted-tbn2.gstatic.com/favicon-tbn?q=tbn:ANd9GcSsVGTdcGOXmWkNxVACTf5kksVw8y9ZfYvRtnwBfyuz1PPbomsxBkOFEwVEYZYfi-_0_hYxgeZPX-n2snLmMsjxn8XYuWo7wjT4XW3w-yGTV2GP_Mk",
        "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTZcwCj38CqjVEFrpOFG3sgZWqVUqcrdVd9Kf-YiznCdHMDAk1d"
      }
    ],
    "knowledge_graph": [
      {
        "title": "Danny DeVito",
        "subtitle": "American actor",
        "link": "https://www.google.com/search?q=Danny+DeVito&kgmid=/m/0q9kd&hl=en&gl=US",
        "thumbnail": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcTROFuWxRRMPIYZy_jI-rJ2Z6Ovi5R5ud7hipf-q6KXc-xmbObf",
        "images": [
          {
            "title": "Image #1 for Danny DeVito",
            "link": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcTROFuWxRRMPIYZy_jI-rJ2Z6Ovi5R5ud7hipf-q6KXc-xmbObf",
            "source": "https://es.wikipedia.org/wiki/Danny_DeVito",
            "width": 1200,
            "height": 1427
          },
          {
            "title": "Image #2 for Danny DeVito",
            "link": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSvIb9xO__VCKd6ZOe9voS42O7opZyq06JE6HrNbeWeZl_TL-sv",
            "source": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcQ0NM-_DE54dgpL3n-zCWVkDfmh_cTdyMvVLqBqT1ddhm_IjZ0A",
            "width": 1080,
            "height": 1440
          },
          {
            "title": "Image #3 for Danny DeVito",
            "link": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcScLEQRG98bI5GhAICFHyeEpfPvCY1U0Mpi8Qv_2smqy1NpzuNy",
            "source": "https://upload.wikimedia.org/wikipedia/commons/6/6d/Danny_DeVito_by_Gage_Skidmore_3.jpg",
            "width": 2058,
            "height": 2416
          },
          {
            "title": "Image #4 for Danny DeVito",
            "link": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcSV9P-Z1oSMnpQXBeHbjl08hFcA83TR1HSrxFCE7ZNXx21Dfkm5",
            "source": "https://br.ign.com/hercules-disney-live-action/101728/news/hercules-danny-devito-quer-retornar-ao-papel-no-live-action",
            "width": 4752,
            "height": 3168
          },
          {
            "title": "Image #5 for Danny DeVito",
            "link": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcSVgDt6PAhdw9Tqzn0fcbQVJir2mKn7_4sveUVqHVVAJb6yDbcN",
            "source": "https://disney.fandom.com/wiki/Danny_DeVito",
            "width": 817,
            "height": 1080
          },
          {
            "title": "Image #6 for Danny DeVito",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQJtY-wIW0qWFIauMNPq3WIY133mQ58K1R5qFqr9MfXfVB-kGQ1",
            "source": "https://www.imdb.com/name/nm0000362/",
            "width": 630,
            "height": 1200
          },
          {
            "title": "Image #7 for Danny DeVito",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRsAx8LkzJLXxXuofFbScOfpZFKKDGbtFBCa9st0C63aE2N4v5F",
            "source": "https://www.adorocinema.com/personalidades/personalidade-237/",
            "width": 1334,
            "height": 1778
          },
          {
            "title": "Image #8 for Danny DeVito",
            "link": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcQfNG2G4Cs9s6_HNFlEnVQ-4UuuqVRJD2J2T0LGX4sB1bfi2XP5",
            "source": "https://www.hollywoodreporter.com/movies/movie-news/danny-devito-disney-haunted-mansion-movie-1235033174/",
            "width": 1296,
            "height": 730
          },
          {
            "title": "Image #9 for Danny DeVito",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQ_w-z4CB0g18O0HCxvaxxzQWsUp95WW_tPNky2CNkcUlTeKMmO",
            "source": "https://bloody-disgusting.com/tv/3614148/fx-orders-animated-horror-comedy-little-demon-starring-danny-devito-aubrey-plaza/",
            "width": 1013,
            "height": 593
          },
          {
            "title": "Image #10 for Danny DeVito",
            "link": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcQtAjzi003674mb06yF2sLoADewJjIe3AW78kX9YCYSBVjETyM4",
            "source": "https://www.vanityfair.com/hollywood/2022/08/danny-devito-little-demon-interview",
            "width": 2000,
            "height": 2630
          }
        ],
        "more_images_link": "https://www.google.com/search?q=Danny+DeVito&kgmid=/m/0q9kd&ved=0EOTpBwgAKAAwAA&source=.lens.button&tbm=isch&hl=en&gl=US"
      },
      {
        "title": "Tony DeVito",
        "subtitle": "American professional wrestler",
        "link": "https://www.google.com/search?q=Tony+DeVito&kgmid=/m/06g2j9&hl=en&gl=US",
        "thumbnail": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcT5L9v36SUDcGqID7sm5vp4EYZE2t-QhFKliIEM7WicmD2Snp3oFGbk2a5B9P-NZI3Bp3w",
        "images": [
          {
            "title": "Image #1 for Tony DeVito",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRedNW_8r2MyrCIcX36tHVNXnlnBqxjE2oleXlNjuGxGdSqJB07",
            "source": "https://wrestlingrecaps.com/2020/10/30/inside-the-magazine-volume-45-pwi-april-94/",
            "width": 1053,
            "height": 803
          },
          {
            "title": "Image #2 for Tony DeVito",
            "link": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcQj1DJ8Fn3j1J9S3xUX40ZE6D9y0j7vqwN5DNEh68ZTPn47IG3V",
            "source": "https://upload.wikimedia.org/wikipedia/commons/a/a6/TonyDeVito2005.png",
            "width": 359,
            "height": 553
          },
          {
            "title": "Image #3 for Tony DeVito",
            "link": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcS5dW6kp7RjioYCJHfGrKz26u3MrUATgIqpl0f4Nnq68YiMGPKV",
            "source": "https://tapemachinesarerolling.tumblr.com/post/89644332659/tony-devito",
            "width": 703,
            "height": 535
          },
          {
            "title": "Image #4 for Tony DeVito",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcR7Xa40rF-bRyg9CVzAeJsLgtd1HsMvY3hiN9TNUKKYTiRuX5eM",
            "source": "https://crej.com/news/tag/aecom/",
            "width": 1200,
            "height": 1200
          },
          {
            "title": "Image #5 for Tony DeVito",
            "link": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcSotOEDK7UhE0jo65LfT_qJK0V_W50xwrw7itaCrXDFPO5cEvK7",
            "source": "https://www.poughkeepsiejournal.com/story/sports/underthering/2022/05/02/under-ring-podcast-veteran-wrestler-tony-devito/9609072002/",
            "width": 1080,
            "height": 1080
          },
          {
            "title": "Image #6 for Tony DeVito",
            "link": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcQ4d7AaJEOzvTBTut_m_0qvQzWp3Paa6yf6wnGTHuEJcasKhRB3",
            "source": "https://mobile.twitter.com/upwroc",
            "width": 1095,
            "height": 1417
          },
          {
            "title": "Image #7 for Tony DeVito",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcR6KHnORY-mb0X59EeuLIBrrUPENX4l4sDqAU_Sd4hMknMJyDMI",
            "source": "https://www.poughkeepsiejournal.com/story/sports/underthering/2022/05/02/under-ring-podcast-veteran-wrestler-tony-devito/9609072002/",
            "width": 1079,
            "height": 607
          },
          {
            "title": "Image #8 for Tony DeVito",
            "link": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSyIIPxKJa6OafYWb7yHayoAR6O3tjyobV8i5tjl6NJ9-qlpMQc",
            "source": "https://www.poughkeepsiejournal.com/story/sports/underthering/2022/05/02/under-ring-podcast-veteran-wrestler-tony-devito/9609072002/",
            "width": 660,
            "height": 371
          },
          {
            "title": "Image #9 for Tony DeVito",
            "link": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSM5aBy1owZZzrkgBQhL4SJhiRECGqBLJy7QaDg4ZJTLad19kRQ",
            "source": "https://mobile.twitter.com/tdevito72",
            "width": 946,
            "height": 2048
          },
          {
            "title": "Image #10 for Tony DeVito",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQoR274yNKuMtNoTJeqin_VLxhh2V0J6H8X6hRtqQVU7ASfES0m",
            "source": "https://www.imdb.com/title/tt1055727/",
            "width": 1700,
            "height": 2338
          }
        ],
        "more_images_link": "https://www.google.com/search?q=Tony+DeVito&kgmid=/m/06g2j9&ved=0EOTpBwgAKAAwAA&source=.lens.button&tbm=isch&hl=en&gl=US"
      },
      {
        "title": "Gage Skidmore",
        "subtitle": "American photographer",
        "link": "https://www.google.com/search?q=Gage+Skidmore&kgmid=/g/11crz_tb2h&hl=en&gl=US",
        "thumbnail": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSfJ7qv71RVbCFpcN0pzT4HJ93Yq0oTsFzruYERqTPidjRgo2EU",
        "images": [
          {
            "title": "Image #1 for Gage Skidmore",
            "link": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSfJ7qv71RVbCFpcN0pzT4HJ93Yq0oTsFzruYERqTPidjRgo2EU",
            "source": "https://www.wonkette.com/tag/gabby-giffords",
            "width": 1024,
            "height": 683
          },
          {
            "title": "Image #2 for Gage Skidmore",
            "link": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcTKHY4NqqK_cSMP5_cWwcxw6QBmizedzapc4ZGhaXz-Q1JqcwgH",
            "source": "https://upload.wikimedia.org/wikipedia/commons/thumb/9/9c/J._D._Vance_by_Gage_Skidmore.jpg/480px-J._D._Vance_by_Gage_Skidmore.jpg",
            "width": 480,
            "height": 599
          },
          {
            "title": "Image #3 for Gage Skidmore",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcReI3wXIJG8ym1E7UAwNTv8crsfBVKDciG3c8J1O5hv_9GnmxU-",
            "source": "https://lookaside.fbsbx.com/lookaside/crawler/media/?media_id=7668657946539423",
            "width": 2048,
            "height": 1365
          },
          {
            "title": "Image #4 for Gage Skidmore",
            "link": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTnD8lnhjg-9Yo4Mbny3fu3fYBKhkbSja0sazUeGTNm6NwLJX5E",
            "source": "https://en.m.wikipedia.org/wiki/File:Seth_MacFarlane_by_Gage_Skidmore_5.jpg",
            "width": 660,
            "height": 768
          },
          {
            "title": "Image #5 for Gage Skidmore",
            "link": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcTFTVsZ8akZFA4xcWTpuP1b6SpiG42HjblDfTcGVoG_Ayw_A6jU",
            "source": "https://www.healthyplace.com/blogs/breakingbipolar/2017/02/professionals-should-talk-about-trumps-mental-health",
            "width": 939,
            "height": 1393
          },
          {
            "title": "Image #6 for Gage Skidmore",
            "link": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcQpi6H5mnWFrJKGhc6GNo8Or55e8SUZnfgMvNlXetPYSWQCg0dB",
            "source": "http://www.gageskidmore.com/",
            "width": 1620,
            "height": 1080
          },
          {
            "title": "Image #7 for Gage Skidmore",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcT2GT-eaNFny1ZFx64ZrixLnb56r8CBkCw0shjehRZ5MJwJuR2t",
            "source": "https://www.flickr.com/photos/gageskidmore/49291176532",
            "width": 1024,
            "height": 683
          },
          {
            "title": "Image #8 for Gage Skidmore",
            "link": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcQQkzkrRIjh-9QGf5EJUSp5Tk1gpSj14_VrwONqRsXrmXxxTBy2",
            "source": "https://www.flickr.com/photos/gageskidmore/33099496276",
            "width": 1024,
            "height": 683
          },
          {
            "title": "Image #9 for Gage Skidmore",
            "link": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcTPAGddurmHEZ8ZhdjMWzfsSHe0nNCI1ohOCNl9lTwLFZ14xXw0",
            "source": "http://www.gageskidmore.com/",
            "width": 1620,
            "height": 1080
          },
          {
            "title": "Image #10 for Gage Skidmore",
            "link": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQ2IDn0z-1U3e4O0V6C_MvvMVeuScci6EtNLJdC0jtI1QcsL65A",
            "source": "http://www.gageskidmore.com/",
            "width": 1620,
            "height": 1080
          }
        ],
        "more_images_link": "https://www.google.com/search?q=Gage+Skidmore&kgmid=/g/11crz_tb2h&ved=0EOTpBwgAKAAwAA&source=.lens.button&tbm=isch&hl=en&gl=US"
      }
    ],
    "detected_objects": [
      {
        "bounding_box": {
          "left": 0.4965157,
          "top": 0.53222656,
          "width": 0.9907085,
          "height": 0.9355469
        },
        "detections": [
          {
            "label": "Danny DeVito",
            "type": "ROSTI",
            "confidence": 96.34284
          },
          {
            "label": "Tony DeVito",
            "type": "ROSTI",
            "confidence": 92.707466
          },
          {
            "label": "Gage Skidmore",
            "type": "ROSTI",
            "confidence": 84.543816
          },
          {
            "label": "Unknown Type",
            "type": "UNIFIED_GRID",
            "confidence": 92.707664
          },
          {
            "label": "Unknown Type",
            "type": "UNIFIED_GRID",
            "confidence": 92.707565
          }
        ]
      },
      {
        "bounding_box": {
          "left": 0.49825785,
          "top": 0.74316406,
          "width": 0.98722416,
          "height": 0.5058594
        },
        "detections": [
          {
            "label": "Unknown Type",
            "type": "UNIFIED_GRID",
            "confidence": 79.009315
          }
        ]
      },
      {
        "bounding_box": {
          "left": 0.44308943,
          "top": 0.30517578,
          "width": 0.55865276,
          "height": 0.15917969
        },
        "detections": [
          {
            "label": "Unknown Type",
            "type": "UNIFIED_GRID",
            "confidence": 0.0001
          }
        ]
      }
    ],
    "searched_object": {
      "bounding_box": {
        "left": 0.4965157,
        "top": 0.53222656,
        "width": 0.9907085,
        "height": 0.9355469
      },
      "detections": [
        {
          "label": "Danny DeVito",
          "type": "ROSTI",
          "confidence": 96.34284
        },
        {
          "label": "Tony DeVito",
          "type": "ROSTI",
          "confidence": 92.707466
        },
        {
          "label": "Gage Skidmore",
          "type": "ROSTI",
          "confidence": 84.543816
        },
        {
          "label": "Unknown Type",
          "type": "UNIFIED_GRID",
          "confidence": 92.707664
        },
        {
          "label": "Unknown Type",
          "type": "UNIFIED_GRID",
          "confidence": 92.707565
        }
      ]
    },
    "reverse_image_search_link": "https://www.google.com/search?tbs=sbi:AMhZZitfwLxg-zRet1hFQpsVY8zva-lRIt2eiO7gwoTZY60_1puxlxOUVEpM6hSpqvlqDEj_1V4FWIAe3vRHPillk_1i1NCQHy8bwVXoHJ_1uT_1YoTaVVqxxq3_16gdwiNCGwYu3ZpdmNIfzcB-_1NOnLeRg65RuvBC2P81g"
  }
}
16

Hi @fdavidg, thank you for sharing this example! It seems like invalid JSON so I’ve made some assumptions here and ended up with this exact dataset. I’ve then tried running the upper branch of your workflow and I think spotted some problems with this.

The first one would be in the Set node. This dynamically sets a value in the “Name” field which is quite uncommon. The “Name” would become the column header when writing the result into a spreadsheet, with the “Value” going into each row.

Now looking at your data, I suspect the results you’re interested in are the ones under data.visual_matches? If so, you could use the Item Lists node to create a single item for each of these results. You could then use a Set node to only keep the columns you are interested in before creating your CSV file in the Write binary data node. For example like so:

This example would leave you with a binary item (an XLS file) which you can then write to the filesystem, upload to Google Drive or send out via email for example:

image
image1919×899 122 KB

image
image1920×1040 278 KB

Can you try copying the workflow above to test it and let me know if this is roughly what you had in mind?

17

MutedJam,

You are awesome! I believe that this workflow will do exactly what I want!

You are exactly correct in your assumption that the reults are mailnly in data.visual_matches.
I am in the process of testing the workflow you provided, but when I copied the workflow n8n choked on the Split out results node ( I assume it is an Items Lists node. I am running version 0.233.1) with the following: “Install this node to use it This node is not currently installed. It is either from a newer version of n8n, a custom node, or has an invalid structure”.

Do I need to update n8n to a later version?

When is version 1.0.0 going to be released? Do you know, yet?

Frank

1 Like
18

but when I copied the workflow n8n choked on the Split out results node

Sorry for that, that’s most likely because I was using a newer version of n8n. You’re quite right this is just a regular Item Lists node. Here’s an updated version of my example workflow which should work on n8n v0.233.1 as well:

Hope this helps :slight_smile:

1 Like
19

Hello MutedJam,

Thank you for the update.

What version are you running?

Anyway, I was able to setup the workflow and it ran just great in both the upper and lower scenarios. Thank you so very much for sticking with me and helping to solve my issues and get the workflow working!

Any recommendations on how to continue on my n8n journey?

I have now totally abandoned the desktop version for the npm version. Next challenges are to get the 1.x.x version running under docker and to get PostgreSQL database setup.

Again thank you very much!

Frank

1 Like
20

Hey @fdavidg, I was running 0.236.2 when writing this post. This version of n8n uses a slightly newer version of the Item Lists node than [email protected], though the basic idea of course works with the older version too :slight_smile:

With regards to version 1, it’s available already and will probably become the “latest stable” version this week. Just be aware that you once you’ve migrated to n8n version 0.234 or later you won’t be able to roll back to an older version (unless you have a full backup of course).

As for the next steps, I’d say implement something you enjoy. Some of the workflows I enjoy more than others are for example:

  1. Measuring my internet speed regularly (this will only make sense if you self-host n8n in your home network) by using the Execute Command node to run speedtest in regular intervals, then store the result in a database.
  2. Check the connection speed in the database from workflow 1 and complain to my internet provider if the average internet speed is considerably less than what they charge me for.
  3. Connect n8n with my Philips Hue desk light. A few minutes before a meeting starts, change the light color so I can wrap up whatever I am currently doing and prepare for the meeting.
  4. Sending data to a smart pixel clock. These workflows are actually inspired by @mallugamer4k, so he’d deserve the credit on this one.

Hope you find some inspiration here

1 Like
21

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.