Input JSON into Array, and then output

How To
1

Dear all,
I have this JSON output (partial shown here) which I got from a HTTP Request so MAKE auto parses it into JSON as I set that. The JSON output contains question/snippet.
How do I parse this properly into an array of some sort, where I can then pick out the Question and Answers in a format like:

Q1
A1
Q2
A2
etc

Below is the output I am trying to tackle :slight_smile: Thank you in advance.

[I cut it short as I am new here, and not allowed to post somethign with more than 10 urls)

“related_questions”: [
{
“question”: “What is loaded potato soup made of?”,
“snippet”: “This creamy soup is a comfort dish ideal for chilly days. It contains all the flavors of a baked potato but can be made in a fraction of the time. Onions, celery, and bacon add powerful flavors to the tender potatoes, while cream, cheddar cheese, and parsley bring the finishing touches.”,
“title”: “Loaded Baked Potato Soup - Wyse Guide”,
“date”: “Jan 8, 2024”,
“link”: “Loaded Baked Potato Soup - Wyse Guide”,
“displayed_link”: “https://www.wyseguide.com › loaded-baked-potato-soup”,
“source_logo”: “https://serpapi.com/searches/661bf96a359e993e27257ad2/images/d6f0f209dbdd779b1bb7bd2d637bce1d3d83a38af18978634b89dd084fba9917.png”,
“next_page_token”: “eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9vQkNreEJUblZYYUdOdFlURjBiWGRpVkMweU5VNTBWalJYWDJFMFRHbDJRMmhmTTBwdldFNDRZVnBKVG1KVGIwWldURXgyV2xNdGJsSkNia00wTkhSRWMxa3lXREkxUVcxRWFHeE5lbTFvRWhaaGRtdGlXblpRZDA1T0xYWTFUbTlRY0hGSFMwbEJHaUpCVUZob2JUVmFlbkZIUTJkdmNrczVkVnBHVkhWclMzQlFRa1JXYzJSS2EzaFIiLCJmY3YiOiIzIiwiZWkiOiJhdmtiWnZQd05OLXY1Tm9QcHFHS0lBIiwicWMiOiJDaGhzYjJGa1pXUWdZbUZyWldRZ2NHOTBZWFJ2SUhOdmRYQVFBSDE2TVEwXyIsInF1ZXN0aW9uIjoiV2hhdCBpcyBsb2FkZWQgcG90YXRvIHNvdXAgbWFkZSBvZj8iLCJsayI6IkdpSjNhR0YwSUdseklHeHZZV1JsWkNCd2IzUmhkRzhnYzI5MWNDQnRZV1JsSUc5bSIsImJzIjoiYy1QeTQxSU96MGdzVWNnc1ZzakpUMHhKVFZFb3lDOUpMTWxYS000dkxWRElCWW9vNUtmWlMyelVOMUtSVWlvbnFKSXJsa3NIYkY1eVlwNkNwMEppU29vQ1VBV3lRaUFORWszTFNTekxMN0tYZUtSbXBDV2xBVFlZS29OUFBWY05seFBNdVNVWnFRb3BtV2xwcVVXcGVjbXBDa21wSmVXcHFYbW9ia3N0VmtqTVMxRklTc3hHRXJLWG1NOWlaQ3hsaUVVenNrS3dUaFRUdUVLNDFEenl5MEZPeWdVcVJGVU5jV3hHWm5KMkt0QmJoMHVNMUtWVU00aFJMTUFJQUEiLCJpZCI6ImZjXzYifQ==”,
“serpapi_link”: “https://serpapi.com/search.json?device=desktop&engine=google_related_questions&google_domain=google.com&next_page_token=eyJvbnMiOiIxMDA0MSIsImZjIjoiRW9vQkNreEJUblZYYUdOdFlURjBiWGRpVkMweU5VNTBWalJYWDJFMFRHbDJRMmhmTTBwdldFNDRZVnBKVG1KVGIwWldURXgyV2xNdGJsSkNia00wTkhSRWMxa3lXREkxUVcxRWFHeE5lbTFvRWhaaGRtdGlXblpRZDA1T0xYWTFUbTlRY0hGSFMwbEJHaUpCVUZob2JUVmFlbkZIUTJkdmNrczVkVnBHVkhWclMzQlFRa1JXYzJSS2EzaFIiLCJmY3YiOiIzIiwiZWkiOiJhdmtiWnZQd05OLXY1Tm9QcHFHS0lBIiwicWMiOiJDaGhzYjJGa1pXUWdZbUZyWldRZ2NHOTBZWFJ2SUhOdmRYQVFBSDE2TVEwXyIsInF1ZXN0aW9uIjoiV2hhdCBpcyBsb2FkZWQgcG90YXRvIHNvdXAgbWFkZSBvZj8iLCJsayI6IkdpSjNhR0YwSUdseklHeHZZV1JsWkNCd2IzUmhkRzhnYzI5MWNDQnRZV1JsSUc5bSIsImJzIjoiYy1QeTQxSU96MGdzVWNnc1ZzakpUMHhKVFZFb3lDOUpMTWxYS000dkxWRElCWW9vNUtmWlMyelVOMUtSVWlvbnFKSXJsa3NIYkY1eVlwNkNwMEppU29vQ1VBV3lRaUFORWszTFNTekxMN0tYZUtSbXBDV2xBVFlZS29OUFBWY05seFBNdVNVWnFRb3BtV2xwcVVXcGVjbXBDa21wSmVXcHFYbW9ia3N0VmtqTVMxRklTc3hHRXJLWG1NOWlaQ3hsaUVVenNrS3dUaFRUdUVLNDFEenl5MEZPeWdVcVJGVU5jV3hHWm5KMkt0QmJoMHVNMUtWVU00aFJMTUFJQUEiLCJpZCI6ImZjXzYifQ%3D%3D”
},

2

Welcome to the Make community!

Since related_questions is an array, you can use an Iterator to split them into bundles, then use a Text Aggregator with the question and answer variables inserted into.

2 Likes