HTTP Request-->autoParse--->Aggregator-->Iterator--> XXX? ---> Data for MYSQL

Hi all,
I got a problem (again).
I have the iterator shwing the attached info. It’s a bunch of arrays and collections. However, I am not able to output it as a plain text file in JSON format or some similar format where it’s all outputted. Purpose is to throw it into MYSQL afterwards. Not sure if I can directly input to MYSQL from, the iterator or it must go through a text aggregator or so? If yes, what is the proper command?
Thank u so much in advance.
========== PS: I truncated some of the output as it cannot fit in here (over limit)

[
{
“search_metadata”: {
“id”: “661eb3c5d5b1c5b820cfb95c”,
“status”: “Success”,
“json_endpoint”: “https://serpapi.com/searches/59eaa533eaa33f1c/661eb3c5d5b1c5b820cfb95c.json”,
“created_at”: “2024-04-16 17:22:13 UTC”,
“processed_at”: “2024-04-16 17:22:14 UTC”,
“google_url”: “Garlic Parmesan Roasted Brussels Sprouts - Google Search”,
“raw_html_file”: “Garlic Parmesan Roasted Brussels Sprouts - Google Search”,
“total_time_taken”: 5.62
},
“search_parameters”: {
“engine”: “google”,
“q”: “Garlic Parmesan Roasted Brussels Sprouts”,
“location_requested”: “Austin, Texas, United States”,
“location_used”: “Austin,Texas,United States”,
“google_domain”: “google.com”,
“hl”: “en”,
“gl”: “us”,
“device”: “desktop”
},
“search_information”: {
“query_displayed”: “Garlic Parmesan Roasted Brussels Sprouts”,
“total_results”: 3900000,
“time_taken_displayed”: 0.36,
“organic_results_state”: “Results for exact spelling”
},
“recipes_results”: [
{
“title”: “Garlic Parmesan Roasted Brussels Sprouts”,
“link”: “Parmesan Roasted Brussels Sprouts Recipe – How to Roast Brussels Sprouts — Eatwell101”,
“source”: “Eatwell101”,
“rating”: 4.8,
“reviews”: 26,
“total_time”: “40 min”,
“ingredients”: [
“Brussels sprouts”
],
“thumbnail”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/0be9c9747f5389834da5a26a228cd560f1eca12e421f4edaba4fa9461e6c1f58.jpeg
},
{
“title”: “Roasted Brussel Sprouts Recipe with Garlic”,
“link”: “Garlic Parmesan Roasted Brussel Sprouts”,
“source”: “Primavera Kitchen”,
“rating”: 3.5,
“reviews”: 332,
“total_time”: “35 min”,
“ingredients”: [
“Brussel sprouts”,
“parmesan cheese”,
“olive oil”,
“lemon juice”,
“garlic”
],
“thumbnail”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/0be9c9747f5389834da5a26a228cd5605b214ad6c8af7fdb27e189bc1e7e9909.jpeg
},
{
“title”: “Roasted Garlic Parmesan Brussels Sprouts Recipe by Tasty”,
“link”: “Roasted Garlic Parmesan Brussels Sprouts Recipe by Tasty”,
“source”: “Tasty”,
“rating”: 4.8,
“reviews”: 1800,
“ingredients”: [
“Brussels sprouts”,
“bread crumbs”,
“parmesan cheese”,
“olive oil”,
“garlic powder”
],
“thumbnail”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/0be9c9747f5389834da5a26a228cd560c15d7e44a5c2826a5bead2ae1ca987a7.jpeg
}
],
“related_questions”: [
{
“question”: “Why are my roasted brussel sprouts not crispy?”,
“snippet”: “Why Are My Brussel Sprouts Not Crispy? Spread them out into a single layer on a rimmed baking sheet to avoid overcrowding. If they’re too close together, they’ll steam instead of roast which stops the crisping process.”,
“title”: “Roasted Brussels Sprouts | The Modern Proper”,
“date”: “Sep 10, 2022”,
“link”: “Roasted Brussels Sprouts | The Modern Proper”,
“displayed_link”: “https://themodernproper.com › roasted-brussels-sprouts”,
“source_logo”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/baff75510b9706e8268e4a45cc59426a578f994a6f1364d3c5ac254f36f76deb.png”,
“next_page_token”: “eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IldoeSBhcmUgbXkgcm9hc3RlZCBicnVzc2VsIHNwcm91dHMgbm90IGNyaXNweT8iLCJsayI6IkdpMTNhSGtnWVhKbElHMTVJSEp2WVhOMFpXUWdZbkoxYzNObGJDQnpjSEp2ZFhSeklHNXZkQ0JqY21semNIayIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ==”,
“serpapi_link”: “https://serpapi.com/search.json?device=desktop&engine=google_related_questions&google_domain=google.com&next_page_token=eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IldoeSBhcmUgbXkgcm9hc3RlZCBicnVzc2VsIHNwcm91dHMgbm90IGNyaXNweT8iLCJsayI6IkdpMTNhSGtnWVhKbElHMTVJSEp2WVhOMFpXUWdZbkoxYzNObGJDQnpjSEp2ZFhSeklHNXZkQ0JqY21semNIayIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ%3D%3D
},
{
“question”: “Is it better to parboil brussel sprouts before roasting?”,
“snippet”: “Beyond bitterness, parboiling your sprouts can speed up cooking times, softening the leaves to tender, right down to their core (without turning them to mush) and making it easy for you to focus on perfectly crispy and caramelized sprouts in less time in the oven, sauté pan, or out on the grill.”,
“title”: “Why You Should Parboil Your Brussels Sprouts In Salt Water”,
“date”: “Jul 20, 2022”,
“link”: “Why You Should Parboil Your Brussels Sprouts In Salt Water”,
“displayed_link”: “https://www.tastingtable.com › why-you-should-parboil-…”,
“source_logo”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/baff75510b9706e8268e4a45cc59426a57828a0bb547892452a0c3d66da8db02.png”,
“next_page_token”: “eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IklzIGl0IGJldHRlciB0byBwYXJib2lsIGJydXNzZWwgc3Byb3V0cyBiZWZvcmUgcm9hc3Rpbmc/IiwibGsiOiJjdzNLd1FuQU1Bd0R3RDM2MGhhZEp3WTNHRUlkSkdYXzl0NTMzU1dVRVdrbjRjWWVqSzZGNEpGeVFadDlySDg4elFSN3lQWE9EdyIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ==”,
“serpapi_link”: “https://serpapi.com/search.json?device=desktop&engine=google_related_questions&google_domain=google.com&next_page_token=eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IklzIGl0IGJldHRlciB0byBwYXJib2lsIGJydXNzZWwgc3Byb3V0cyBiZWZvcmUgcm9hc3Rpbmc%2FIiwibGsiOiJjdzNLd1FuQU1Bd0R3RDM2MGhhZEp3WTNHRUlkSkdYXzl0NTMzU1dVRVdrbjRjWWVqSzZGNEpGeVFadDlySDg4elFSN3lQWE9EdyIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ%3D%3D
},
{
“question”: “Is it better to cut brussel sprouts before roasting?”,
“snippet”: “Halved: Halved Brussel sprouts are the classic cut for sheet-pan roasting or sautéing. Sliced: Crisp these guys up in the air fryer. They are also great for sautéing and roasting – especially if you start with the larger sprouts and want to cut them into bite-sized pieces.”,
“title”: “How to Cut Brussel Sprouts - Feel Good Foodie”,
“date”: “Dec 11, 2020”,
“link”: “How to Cut Brussel Sprouts {Step-by-Step Tutorial} - FeelGoodFoodie”,
“displayed_link”: “https://feelgoodfoodie.net › recipe › how-to-cut-brussel-s…”,
“source_logo”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/baff75510b9706e8268e4a45cc59426ab0a23fdd2c6cc1e25f44f3abf40f2d53.png”,
“next_page_token”: “eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IklzIGl0IGJldHRlciB0byBjdXQgYnJ1c3NlbCBzcHJvdXRzIGJlZm9yZSByb2FzdGluZz8iLCJsayI6ImM1TXl6aXhXeUN4UlNFb3RLVWt0VWlqSlYwZ3VCZktLU291TFUzTVVpZ3VLOGt0TGlvR3lhZmxGcVFwRi1ZbkZKWmw1NlFBIiwiYnMiOiJjNTJRUFE2Q01CaEE0OXBGUnRMcHU0Q2FGSXc2TVRnNU9qRzNVS1ZKYlp2MmE0QURlQXF2NGwyOGlzS0lnejhIZU84bGo5UmtXVFk5Y0NfaDBvTzNQS0NzUWZnWWd0UVFuTGNSQXhpTFVIa1ZYRi1ranpsYjBVWDdDMFE2c2owRVVBaENJa29QYU1GeEw2elNiNVNRSl92eWpsSmx6a1Y2M2JNZDNhal9jT0pJUGkxWEVUOVhid2xiMDJ4YV9RSWxobVJsd3hGQ1k2T3V4d3RDZ3RQY0RKT003SEF3VFN4RmVqLXluTEwyWnpLWlBRRSIsImlkIjoiZmNfMiJ9”,
“serpapi_link”: “https://serpapi.com/search.json?device=desktop&engine=google_related_questions&google_domain=google.com&next_page_token=eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IklzIGl0IGJldHRlciB0byBjdXQgYnJ1c3NlbCBzcHJvdXRzIGJlZm9yZSByb2FzdGluZz8iLCJsayI6ImM1TXl6aXhXeUN4UlNFb3RLVWt0VWlqSlYwZ3VCZktLU291TFUzTVVpZ3VLOGt0TGlvR3lhZmxGcVFwRi1ZbkZKWmw1NlFBIiwiYnMiOiJjNTJRUFE2Q01CaEE0OXBGUnRMcHU0Q2FGSXc2TVRnNU9qRzNVS1ZKYlp2MmE0QURlQXF2NGwyOGlzS0lnejhIZU84bGo5UmtXVFk5Y0NfaDBvTzNQS0NzUWZnWWd0UVFuTGNSQXhpTFVIa1ZYRi1ranpsYjBVWDdDMFE2c2owRVVBaENJa29QYU1GeEw2elNiNVNRSl92eWpsSmx6a1Y2M2JNZDNhal9jT0pJUGkxWEVUOVhid2xiMDJ4YV9RSWxobVJsd3hGQ1k2T3V4d3RDZ3RQY0RKT003SEF3VFN4RmVqLXluTEwyWnpLWlBRRSIsImlkIjoiZmNfMiJ9
},
{
“question”: “What should not be planted next to brussel sprouts?”,
“snippet”: “Just as you like some people and dislike others, Brussels sprouts feel the same way. Don’t grow strawberries, kohlrabi, or pole beans near these plants.”,
“title”: “Brussels Sprouts Companion Plants - Gardening Know How”,
“date”: “Feb 17, 2023”,
“link”: “Brussels Sprout Plant Companions: Suitable Companions For Brussels Sprouts | Gardening Know How”,
“displayed_link”: “https://www.gardeningknowhow.com › edible › vegetables”,
“source_logo”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/baff75510b9706e8268e4a45cc59426a160b3557e4da5cdd5713b6152edb625b.png”,
“next_page_token”: “eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IldoYXQgc2hvdWxkIG5vdCBiZSBwbGFudGVkIG5leHQgdG8gYnJ1c3NlbCBzcHJvdXRzPyIsImxrIjoiR2pKM2FHRjBJSE5vYjNWc1pDQnViM1FnWW1VZ2NHeGhiblJsWkNCdVpYaDBJSFJ2SUdKeWRYTnpaV3dnYzNCeWIzVjBjdyIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ==”,
“serpapi_link”: “https://serpapi.com/search.json?device=desktop&engine=google_related_questions&google_domain=google.com&next_page_token=eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IldoYXQgc2hvdWxkIG5vdCBiZSBwbGFudGVkIG5leHQgdG8gYnJ1c3NlbCBzcHJvdXRzPyIsImxrIjoiR2pKM2FHRjBJSE5vYjNWc1pDQnViM1FnWW1VZ2NHeGhiblJsWkNCdVpYaDBJSFJ2SUdKeWRYTnpaV3dnYzNCeWIzVjBjdyIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ%3D%3D
}
],
“organic_results”: [
{
“position”: 1,
“title”: “Garlic Parmesan Roasted Brussels Sprouts”,
“link”: “Parmesan Roasted Brussels Sprouts Recipe – How to Roast Brussels Sprouts — Eatwell101”,
“redirect_link”: “https://www.google.comhttps://www.eatwell101.com/parmesan-roasted-brussels-sprouts”,
“displayed_link”: “https://www.eatwell101.com › Recipes”,
“thumbnail”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce14707fd54b42563066cb5237abb3d64492.jpeg”,
“favicon”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce1431f637b637e0013171867fdcf195741b.png”,
“snippet”: “Ingredients list for the parmesan Brussels sprouts · 16 oz (450g) Brussels sprouts, rinsed · 3 tablespoons olive oil (or melted butter) · 1/2 teaspoon kosher …”,
“snippet_highlighted_words”: [
“parmesan Brussels sprouts”,
“Brussels sprouts”
],
“rich_snippet”: {
“bottom”: {
“detected_extensions”: {
“rating”: 4.8,
“votes”: 26,
“min”: 40
},
“extensions”: [
“Rating: 4.8”,
“26 votes”,
“40 min”
]
}
},
“source”: “Eatwell101”
},
{
“position”: 2,
“title”: “Roasted Garlic Parmesan Brussels Sprouts”,
“link”: “Roasted Garlic Parmesan Brussels Sprouts Recipe by Tasty”,
“redirect_link”: “https://www.google.comhttps://tasty.co/recipe/roasted-garlic-parmesan-brussels-sprouts”,
“displayed_link”: “https://tasty.co › Meal › Dinner › Weeknight”,
“thumbnail”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce149e8bbe4f1cebfee74077e3f14e112873.jpeg”,
“favicon”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce1436fb437e79487362be5ecebe4d63012a.png”,
“date”: “May 4, 2023”,
“snippet”: “Ingredients · 1 lb brussels sprouts, halved · 4 tablespoons olive oil · ½ teaspoon salt · 1 teaspoon pepper · 1 teaspoon garlic powder · ¼ cup …”,
“snippet_highlighted_words”: [
“brussels sprouts”,
“garlic”
],
“rich_snippet”: {
“bottom”: {
“detected_extensions”: {
“rating”: 4.8,
“votes”: 1803
},
“extensions”: [
“Rating: 4.8”,
“1,803 votes”
]
}
},
“source”: “Tasty”
},
{
“position”: 3,
“title”: “Garlic Parmesan Roasted Brussel Sprouts”,
“link”: “Garlic Parmesan Roasted Brussel Sprouts”,
“redirect_link”: “https://www.google.comhttps://www.primaverakitchen.com/garlic-parmesan-roasted-brussels-sprouts/”,
“displayed_link”: “https://www.primaverakitchen.com › Side dishes”,
“thumbnail”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce14cef667d3e659a82276fbc10b5ef58b3a.jpeg”,
“favicon”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce1490b7451daef0f923a80a4f2434fb05fe.png”,
“date”: “Nov 8, 2023”,
“snippet”: “This easy-to-make Garlic Parmesan Roasted Brussel Sprouts recipe is a delicious side dish made with lemon, Parmesan cheese, extra virgin …”,
“snippet_highlighted_words”: [
“Garlic Parmesan Roasted Brussel Sprouts”
],
“rich_snippet”: {
“bottom”: {
“detected_extensions”: {
“rating”: 3.5,
“votes”: 332,
“min”: 35
},
“extensions”: [
“Rating: 3.5”,
“332 votes”,
“35 min”
]
}
},
“source”: “Primavera Kitchen”
},
{
“position”: 4,
“title”: “Garlic Parmesan Roasted Brussels Sprouts”,
“link”: “Garlic Parmesan Roasted Brussels Sprouts”,
“redirect_link”: “https://www.google.comhttps://www.jocooks.com/recipes/garlic-parmesan-roasted-brussels-sprouts/”,
“displayed_link”: “https://www.jocooks.com › Recipes”,
“thumbnail”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce143e9c7f738166701cb86729da09e88825.jpeg”,
“favicon”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce14013dbfeb2c07fda9eb8f785e0a29dc6f.png”,
“date”: “Jun 13, 2022”,
“snippet”: “These perfectly crispy Garlic Parmesan Roasted Brussels Sprouts are easy and quick to put together and only calls for a few ingredients.”,
“snippet_highlighted_words”: [
“Garlic Parmesan Roasted Brussels Sprouts”
],
“rich_snippet”: {
“bottom”: {
“detected_extensions”: {
“rating”: 4.5,
“votes”: 56,
“min”: 20
},
“extensions”: [
“Rating: 4.5”,
“56 votes”,
“20 min”
]
}
},
“source”: “Jo Cooks”
},
{
“position”: 5,
“title”: “CRISPY Parmesan Roasted Brussels Sprouts (addictive!)”,
“link”: “CRISPY Parmesan Roasted Brussels Sprouts (addictive!)”,
“redirect_link”: “https://www.google.comhttps://www.recipetineats.com/crispy-parmesan-roasted-brussels-sprouts/”,
“displayed_link”: “https://www.recipetineats.com › Veg and Salad Sides”,
“thumbnail”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce14e44c118e95e1ee1d92cf32568e3bce24.jpeg”,
“favicon”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce14b62a676cd488835848de807845b42091.png”,
“date”: “Oct 23, 2019”,
“snippet”: “Ingredients · ▢ 500g/ 1lb brussels sprouts (Note 1) · ▢ 2 tbsp extra virgin olive oil · ▢ 2 garlic cloves , minced · ▢ 1/2 tsp salt · ▢ 1/4 tsp …”,
“snippet_highlighted_words”: [
“brussels sprouts”,
“garlic”
],
“rich_snippet”: {
“bottom”: {
“detected_extensions”: {
“rating”: 4.9,
“votes”: 28,
“min”: 35
},
“extensions”: [
“Rating: 4.9”,
“28 votes”,
“35 min”
]
}
},
“source”: “RecipeTin Eats”
},
{
“position”: 6,
“title”: “Garlic Parmesan Roasted Brussels Sprouts Recipe”,
“link”: “https://www.food.com/recipe/garlic-parmesan-roasted-brussels-sprouts-494102”,
“redirect_link”: “https://www.google.comhttps://www.food.com/recipe/garlic-parmesan-roasted-brussels-sprouts-494102”,
“displayed_link”: “https://www.food.com › Recipes › Vegetable”,
“thumbnail”: “https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQHWJfemKyU_p8s_hMDA59VKfkv2fVgy3FF-lvIuMU6IkI0e4Av6Flr&usqp=CAE&s”,
“favicon”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce14029e720770042c5d6bb502b79fdf0845.png”,
“snippet”: “Preheat oven to 400 ° F. Toss together Brussels sprouts, garlic cloves, olive oil, lemon pepper, and salt; spread on a baking sheet. Roast for 20-25 minutes …”,
“snippet_highlighted_words”: [
“Brussels sprouts”,
“garlic”,
“Roast”
],
“rich_snippet”: {
“bottom”: {
“detected_extensions”: {
“rating”: 5,
“reviews”: 4,
“min”: 25
},
“extensions”: [
“Rating: 5”,
“4 reviews”,
“25 min”
]
}
},
“source”: “Food.com
},
{
“position”: 7,
“title”: “Garlic-Parmesan Roasted Brussels Sprouts”,
“link”: “Garlic-Parmesan Roasted Brussels Sprouts”,
“redirect_link”: “https://www.google.comhttps://www.eatingwell.com/recipe/251284/garlic-parmesan-roasted-brussels-sprouts/”,
“displayed_link”: “https://www.eatingwell.com › recipe › garlic-parmesan-…”,
“thumbnail”: “https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQmTYuOcrqpH3Wl-R71KQQCnPJhZZgCRFs13JhljaIIjYPZgwqnWlTB&usqp=CAE&s”,
“favicon”: “https://serpapi.com/searches/661eb3c5d5b1c5b820cfb95c/images/edbee3176a0eae945ea733319acfce14868313b80cbd538a9c41fb63eab7f58a.png”,
“date”: “Sep 20, 2023”,
“snippet”: “Ingredients · 2 pounds Brussels sprouts, trimmed and halved (or quartered if large) · 1 small lemon, sliced · 4 cloves garlic, sliced · ¼ cup …”,
“snippet_highlighted_words”: [
“Brussels sprouts”,
“garlic”
],
“rich_snippet”: {
“bottom”: {
“detected_extensions”: {
“rating”: 5,
“votes”: 5,
“min”: 30
},
“extensions”: [
“Rating: 5”,
“5 votes”,
“30 min”
]
}
]

How is your HTTP module set up?

In your HTTP module settings “Parse response” field, select “YES” (it is “No” by default)

Screenshot_2023-12-19_141214

This will allow you to map the response collection properties (variables) in subsequent modules.

If you want the RAW string response of the HTTP module, then leave it as “No”, then you can map the entire “Data” body.

2 Likes