Skip to content
HTTP Request -> aut...
 
Notifications
Clear all

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

2 Posts
2 Users
0 Reactions
4 Views
Cyau1983
(@cyau1983)
Posts: 1
New Member
Topic starter
 

Hi everyone,

I'm encountering an issue again.

I have an iterator displaying the attached information, which consists of several arrays and collections. However, I'm unable to output this data as a plain text file in JSON format or a similar structure that consolidates everything. The goal is to import this data into MySQL afterward. I'm unsure if I can directly input data into MySQL from the iterator, or if it needs to pass through a text aggregator first. If the latter, what would be the appropriate command?

Thank you in advance for your help.

==========

PS: I've truncated some of the output as it exceeded the character limit.

[
{
“searchmetadata”: {
“id”: “661eb3c5d5b1c5b820cfb95c”,
“status”: “Success”,
“json
endpoint”: “ https://serpapi.com/searches/59eaa533eaa33f1c/661eb3c5d5b1c5b820cfb95c.json ”,
“createdat”: “2024-04-16 17:22:13 UTC”,
“processed
at”: “2024-04-16 17:22:14 UTC”,
“googleurl”: “Garlic Parmesan Roasted Brussels Sprouts - Google Search”,
“raw
htmlfile”: “ https://serpapi.com/searches/59eaa533eaa33f1c/661eb3c5d5b1c5b820cfb95c.html ”,
“total
timetaken”: 5.62
},
“search
parameters”: {
“engine”: “google”,
“q”: “Garlic Parmesan Roasted Brussels Sprouts”,
“locationrequested”: “Austin, Texas, United States”,
“location
used”: “Austin,Texas,United States”,
“googledomain”: “google.com”,
“hl”: “en”,
“gl”: “us”,
“device”: “desktop”
},
“search
information”: {
“querydisplayed”: “Garlic Parmesan Roasted Brussels Sprouts”,
“total
results”: 3900000,
“timetakendisplayed”: 0.36,
“organicresultsstate”: “Results for exact spelling”
},
“recipesresults”: [
{
“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”: “
},
{
“title”: “Roasted Brussel Sprouts Recipe with Garlic”,
“link”: “Garlic Parmesan Roasted Brussel Sprouts”,
“source”: “Primavera Kitchen”,
“rating”: 3.5,
“reviews”: 332,
“totaltime”: “35 min”,
“ingredients”: [
“Brussel sprouts”,
“parmesan cheese”,
“olive oil”,
“lemon juice”,
“garlic”
],
“thumbnail”: “
},
{
“title”: “Roasted Garlic Parmesan Brussels Sprouts Recipe by Tasty”,
“link”: “Roasted Garlic Parmesan Brussels Sprouts Recipe - Tasty”,
“source”: “Tasty”,
“rating”: 4.8,
“reviews”: 1800,
“ingredients”: [
“Brussels sprouts”,
“bread crumbs”,
“parmesan cheese”,
“olive oil”,
“garlic powder”
],
“thumbnail”: “
}
],
“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”,
“displayedlink”: “ https://themodernproper.com › roasted-brussels-sprouts”,
“source
logo”: “ ”,
“nextpagetoken”: “eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IldoeSBhcmUgbXkgcm9hc3RlZCBicnVzc2VsIHNwcm91dHMgbm90IGNyaXNweT8iLCJsayI6IkdpMTNhSGtnWVhKbElHMTVJSEp2WVhOMFpXUWdZbkoxYzNObGJDQnpjSEp2ZFhSeklHNXZkQ0JqY21semNIayIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ==”,
“serpapilink”: “ https://serpapi.com/search.json?device=desktop&engine=google relatedquestions&googledomain=google.com&nextpagetoken=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”,
“displayedlink”: “ https://www.tastingtable.com › why-you-should-parboil-…”,
“source
logo”: “ ”,
“nextpagetoken”: “eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IklzIGl0IGJldHRlciB0byBwYXJib2lsIGJydXNzZWwgc3Byb3V0cyBiZWZvcmUgcm9hc3RpbmcIiwibGsiOiJjdzNLd1FuQU1Bd0R3RDM2MGhhZEp3WTNHRUlkSkdYXzl0NTMzU1dVRVdrbjRjWWVqSzZGNEpGeVFadDlySDg4elFSN3lQWE9EdyIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ==”,
“serpapi
link”: “<a href="" https://serpapi.com/search.json?device=desktop&engine=googl e"relatedquestions&googledomain=google.com&nextpagetoken=eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IklzIGl0IGJldHRlciB0byBwYXJib2lsIGJydXNzZWwgc3Byb3V0cyBiZWZvcmUgcm9hc3RpbmcIiwibGsiOiJjdzNLd1FuQU1Bd0R3RDM2MGhhZEp3WTNHRUlkSkdYXzl0NTMzU1dVRVdrbjRjWWVqSzZGNEpGeVFadDlySDg4elFSN3lQWE9EdyIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ%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} - Feel Good Foodie”,
“displayedlink”: “ https://feelgoodfoodie.net › recipe › how-to-cut-brussel-s…”,
“source
logo”: “ ”,
“nextpagetoken”: “eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IklzIGl0IGJldHRlciB0byBjdXQgYnJ1c3NlbCBzcHJvdXRzIGJlZm9yZSByb2FzdGluZz8iLCJsayI6ImM1TXl6aXhXeUN4UlNFb3RLVWt0VWlqSlYwZ3VCZktLU291TFUzTVVpZ3VLOGt0TGlvR3lhZmxGcVFwRi1ZbkZKWmw1NlFBIiwiYnMiOiJjNTJRUFE2Q01CaEE0OXBGUnRMcHU0Q2FGSXc2TVRnNU9qRzNVS1ZKYlp2MmE0QURlQXF2NGwyOGlzS0lnejhIZU84bGo5UmtXVFk5Y0NfaDBvTzNQS0NzUWZnWWd0UVFuTGNSQXhpTFVIa1ZYRi1ranpsYjBVWDdDMFE2c2owRVVBaENJa29QYU1GeEw2elNiNVNRSl92eWpsSmx6a1Y2M2JNZDNhal9jT0pJUGkxWEVUOVhid2xiMDJ4YV9RSWxobVJsd3hGQ1k2T3V4d3RDZ3RQY0RKT003SEF3VFN4RmVqLXluTEwyWnpLWlBRRSIsImlkIjoiZmNfMiJ9”,
“serpapilink”: “<a href="" https://serpapi.com/search.json?device=desktop&engine=googl e"relatedquestions&googledomain=google.com&nextpagetoken=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”,
“displayedlink”: “ https://www.gardeningknowhow.com › edible › vegetables”,
“source
logo”: “ ”,
“nextpagetoken”: “eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IldoYXQgc2hvdWxkIG5vdCBiZSBwbGFudGVkIG5leHQgdG8gYnJ1c3NlbCBzcHJvdXRzPyIsImxrIjoiR2pKM2FHRjBJSE5vYjNWc1pDQnViM1FnWW1VZ2NHeGhiblJsWkNCdVpYaDBJSFJ2SUdKeWRYTnpaV3dnYzNCeWIzVjBjdyIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ==”,
“serpapilink”: “<a href="" https://serpapi.com/search.json?device=desktop&engine=googl e"relatedquestions&googledomain=google.com&nextpagetoken=eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9zQkNreEJUblZYYUdOdVpEUkhhbnBPV1RGNllqbENNM2N6VjNrMFpHdHNYM2wyU0ZOQ09WcG1jbTgwUlcxMVRHWjBaRXgyUzB0WFlYSTRPVVpDVVcxMVJWVmxkSFptTW5jM1lWbDRTSGRQRWhkNWNrMWxXblZwYjBwT1JHeHpaVTFRTTNaSFJUUkJaeG9pUVZCWWFHMDFZa2RMZGxsb1dVMDFPR05HTTJadlVXeFNaaTFqYzNoMVdHdHhVUSIsImZjdiI6IjMiLCJlaSI6InlyTWVadWlvSk5EbHNlTVAzdkdFNEFnIiwicWMiOiJDaWhuWVhKc2FXTWdjR0Z5YldWellXNGdjbTloYzNSbFpDQmljblZ6YzJWc2N5QnpjSEp2ZFhSekVBQjk3aVQyUGciLCJxdWVzdGlvbiI6IldoYXQgc2hvdWxkIG5vdCBiZSBwbGFudGVkIG5leHQgdG8gYnJ1c3NlbCBzcHJvdXRzPyIsImxrIjoiR2pKM2FHRjBJSE5vYjNWc1pDQnViM1FnWW1VZ2NHeGhiblJsWkNCdVpYaDBJSFJ2SUdKeWRYTnpaV3dnYzNCeWIzVjBjdyIsImJzIjoiYzUyUVBRNkNNQmhBNDlwRlJ0THB1NENhRkl3Nk1UZzVPakczVUtWSmJadjJhNEFEZUFxdjRsMjhpc0tJZ3o4SGVPOGxqOVJrV1RZOWNDX2gwb08zUEtDc1FmZ1lndFFRbkxjUkF4aUxVSGtWWEYta2p6bGIwVVg3QzBRNnNqMEVVQWhDSWtvUGFNRnhMNnpTYjVTUUpfdnlqbEpsemtWNjNiTWQzYWpfY09KSVBpMVhFVDlYYndsYjAyeGFfUUlsaG1 SbHd4RkNZNk91eHd0Q2d0UGNESk9NN0hBd1RTeEZlai15bkxMMlp6S1pQUUUiLCJpZCI6ImZjXzIifQ%3D%3D”
}
],
“organicresults”: [
{
“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”,
“displayedlink”: “ https://www.eatwell101.com › Recipes”,
“thumbnail”: “ ”,
“favicon”: “ ”,
“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
highlightedwords”: [
“parmesan Brussels sprouts”,
“Brussels sprouts”
],
“rich
snippet”: {
“bottom”: {
“detectedextensions”: {
“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 - Tasty”,
“redirect
link”: “ https://www.google.comhttps ://tasty.co/recipe/roasted-garlic-parmesan-brussels-sprouts”,
“displayedlink”: “ https://tasty.co › Meal › Dinner › Weeknight”,
“thumbnail”: “ ”,
“favicon”: “ ”,
“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
highlightedwords”: [
“brussels sprouts”,
“garlic”
],
“rich
snippet”: {
“bottom”: {
“detectedextensions”: {
“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/”,
“displayedlink”: “ https://www.primaverakitchen.com › Side dishes”,
“thumbnail”: “ ”,
“favicon”: “ ”,
“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
highlightedwords”: [
“Garlic Parmesan Roasted Brussel Sprouts”
],
“rich
snippet”: {
“bottom”: {
“detectedextensions”: {
“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/”,
“displayedlink”: “ https://www.jocooks.com › Recipes”,
“thumbnail”: “ ”,
“favicon”: “ ”,
“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
highlightedwords”: [
“Garlic Parmesan Roasted Brussels Sprouts”
],
“rich
snippet”: {
“bottom”: {
“detectedextensions”: {
“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/”,
“displayedlink”: “ https://www.recipetineats.com › Veg and Salad Sides”,
“thumbnail”: “ ”,
“favicon”: “ ”,
“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
highlightedwords”: [
“brussels sprouts”,
“garlic”
],
“rich
snippet”: {
“bottom”: {
“detectedextensions”: {
“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”,
“displayedlink”: “ https://www.food.com › Recipes › Vegetable”,
“thumbnail”: “ https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQHWJfemKyU
p8shMDA59VKfkv2fVgy3FF-lvIuMU6IkI0e4Av6Flr&usqp=CAE&s”,
“favicon”: “ ”,
“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
highlightedwords”: [
“Brussels sprouts”,
“garlic”,
“Roast”
],
“rich
snippet”: {
“bottom”: {
“detectedextensions”: {
“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/”,
“displayedlink”: “ https://www.eatingwell.com › recipe › garlic-parmesan-…”,
“thumbnail”: “ https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQmTYuOcrqpH3Wl-R71KQQCnPJhZZgCRFs13JhljaIIjYPZgwqnWlTB&usqp=CAE&s ”,
“favicon”: “ ”,
“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
highlightedwords”: [
“Brussels sprouts”,
“garlic”
],
“rich
snippet”: {
“bottom”: {
“detected_extensions”: {
“rating”: 5,
“votes”: 5,
“min”: 30
},
“extensions”: [
“Rating: 5”,
“5 votes”,
“30 min”
]
}
}
}
]
}
]

 
Posted : 16/04/2024 5:29 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

How is your HTTP module configured?

In your HTTP module settings, under the "Parse response" field, select "YES" (the default is "No").

Screenshot_2023-12-19_141214

This setting enables you to map the response collection properties (variables) in subsequent modules.

If you need the RAW string response from the HTTP module, keep the setting as "No". In that case, you can map the entire "Data" body.

 
Posted : 17/04/2024 2:51 am
Share: