I tried to store Google Reviews in a child CPT. I would like to use the place queried by the API as the parent, and add the place’s reviews as child CPT’s.
This does not work because the API Query Builder does not recognise the parent in the returned JSON.
If I set the source type of the API call to ‘Custom JSON’ and add brackets around the custom JSON, the API Query Builder creates a CPT with the parent ID, and creates the reviews as child CPT’s
This is what the Google API returns. No CPT’s are created.
{
"id": "ChIJGcDVwC7JxUcRumA7QB26xqU",
"displayName": {
"text": "Huidtherapeut",
"languageCode": "nl"
},
"reviews": [
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/ChZDSUhNMG9nS0VJQ0FnSURudGVLSWR3EAE",
"relativePublishTimeDescription": "a year ago",
"rating": 5,
"text": {
"text": "Thank you so much Shivani.\nI had a pleasant experience.\nMy skin has now a glow and feels tighter.",
"languageCode": "en"
},
"originalText": {
"text": "Thank you so much Shivani.\nI had a pleasant experience.\nMy skin has now a glow and feels tighter.",
"languageCode": "en"
},
"authorAttribution": {
"displayName": "Nina Promintos",
"uri": "https://www.google.com/maps/contrib/111138478969449042780/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocJharC68FHbx6xYNN6M-aZLBnKXU0nxv_FprijNHZVyEd-pqw=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2024-10-08T09:02:26.056182Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=ChZDSUhNMG9nS0VJQ0FnSURudGVLSWR3EAE&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sChZDSUhNMG9nS0VJQ0FnSURudGVLSWR3EAE!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
},
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/Ci9DQUlRQUNvZENodHljRjlvT2w5eVNYSmZkREYxV0haeWJqbFVWM050VkhOVE9IYxAB",
"relativePublishTimeDescription": "a month ago",
"rating": 5,
"text": {
"text": "Complaints about edema aren't always understood or taken seriously everywhere. But here, you certainly feel heard and seen. Luna and Julia are very friendly and work calmly and professionally.\nThey're very pleasant to chat with throughout the treatment (which can be quite sensitive), making it easier to relax in a pleasant atmosphere.",
"languageCode": "en-US"
},
"originalText": {
"text": "Klachten rondom oedeem worden niet altijd overal begrepen of serieus genomen. Maar hier voel je je iig gehoord en gezien. Luna en Julia zijn zeer vriendelijk en werken rustig en professioneel.\nKletsen je heel fijn door de behandeling heen (die best wel gevoelig kan zijn) waardoor het makkelijker is je te ontspannen in een prettige sfeer.",
"languageCode": "nl"
},
"authorAttribution": {
"displayName": "Marieke Hooyenga-van de Vaart",
"uri": "https://www.google.com/maps/contrib/117412472654758489905/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocLGv6Hsn-tEzoPf6_lVJr3AqpjXeyKTdlQZl6jgq2iyq9kqDA=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2026-02-10T08:52:40.144698886Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=Ci9DQUlRQUNvZENodHljRjlvT2w5eVNYSmZkREYxV0haeWJqbFVWM050VkhOVE9IYxAB&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sCi9DQUlRQUNvZENodHljRjlvT2w5eVNYSmZkREYxV0haeWJqbFVWM050VkhOVE9IYxAB!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
},
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/Ci9DQUlRQUNvZENodHljRjlvT210aVV6VmxOemhwVGtONGMwbG1kSFJ0YjFOMmMzYxAB",
"relativePublishTimeDescription": "a month ago",
"rating": 5,
"text": {
"text": "Julia is very friendly and helped me skillfully and professionally.",
"languageCode": "en-US"
},
"originalText": {
"text": "Julia is erg aanrdig en heeft mij kundig en professioneel geholpen.",
"languageCode": "nl"
},
"authorAttribution": {
"displayName": "Margreet",
"uri": "https://www.google.com/maps/contrib/107982904946390074645/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocI7gwhsNlqjP7X7xmtQ_HuY5mmEZGT3QxBlJ6h8bxoA_T7I6Q=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2026-01-24T09:35:58.887273153Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=Ci9DQUlRQUNvZENodHljRjlvT210aVV6VmxOemhwVGtONGMwbG1kSFJ0YjFOMmMzYxAB&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sCi9DQUlRQUNvZENodHljRjlvT210aVV6VmxOemhwVGtONGMwbG1kSFJ0YjFOMmMzYxAB!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
},
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/ChZDSUhNMG9nS0VJQ0FnSUNEa3NYcVZREAE",
"relativePublishTimeDescription": "a year ago",
"rating": 5,
"text": {
"text": "Shivani helped me very professionally. I was really hesitant about the treatment, but Shivani really took the time to explain everything to me. This helped me better understand the options available to me. This allowed me to make the right choice, taking my wishes and budget into account.",
"languageCode": "en-US"
},
"originalText": {
"text": "Ik ben heel professioneel geholpen door Shivani. Ik was echt aan het twijfellen over de behandeling maar Shivani heeft echt de tijd genomen om me alles goed uit te leggen. Hierdoor begreep ik beter\nwat mogenlijkheden voor mij zijn. Ik heb zo de juiste keuze kunnen maken rekening houdend met mijn wensen en budget.",
"languageCode": "nl"
},
"authorAttribution": {
"displayName": "Mina Koendan",
"uri": "https://www.google.com/maps/contrib/108801267209626612458/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocJky-yyE6aEuKyZVRO-WRXQhWn0hBHK0d9hD5eCx99T384m4w=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2024-03-26T09:15:14.865699Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=ChZDSUhNMG9nS0VJQ0FnSUNEa3NYcVZREAE&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sChZDSUhNMG9nS0VJQ0FnSUNEa3NYcVZREAE!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
},
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/ChZDSUhNMG9nS0VJQ0FnTUR3b2FYZkdREAE",
"relativePublishTimeDescription": "11 months ago",
"rating": 5,
"text": {
"text": "I've been at the skin clinic for a few weeks now, and I can only say that it's very friendly.\nAnd Shivanni is super friendly.\nAnd very knowledgeable.\nShe takes you seriously, and is always very pleasant and welcoming.\nKind regards, Loes",
"languageCode": "en-US"
},
"originalText": {
"text": "Ik ben sinds een aantal weken bij de huid kliniek, en kan niet anders zeggen dat het er heel vriendelijk aan toe gaat\nEn shivanni is super vriendelijk.\nEn heel kundig.\nNeemt je seriues, en altijd heel fijn en gezellig.\nVriendelijke groet Loes",
"languageCode": "nl"
},
"authorAttribution": {
"displayName": "Loes",
"uri": "https://www.google.com/maps/contrib/107112285795087856750/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocKG89HgArZdH-E7Ut_D6ewK7-KbgItOJDCjTENhIc5mmBCOCy8=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2025-03-26T15:45:37.419093Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=ChZDSUhNMG9nS0VJQ0FnTUR3b2FYZkdREAE&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sChZDSUhNMG9nS0VJQ0FnTUR3b2FYZkdREAE!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
}
]
}
If I set the source type of the API call to ‘Custom JSON’ and add brackets around the custom JSON, the API Query Builder creates a CPT with the parent ID, and creates the reviews as child CPT’s:
[
{
"id": "ChIJGcDVwC7JxUcRumA7QB26xqU",
"displayName": {
"text": "Huidtherapeut",
"languageCode": "nl"
},
"reviews": [
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/ChZDSUhNMG9nS0VJQ0FnSURudGVLSWR3EAE",
"relativePublishTimeDescription": "a year ago",
"rating": 5,
"text": {
"text": "Thank you so much Shivani.\nI had a pleasant experience.\nMy skin has now a glow and feels tighter.",
"languageCode": "en"
},
"originalText": {
"text": "Thank you so much Shivani.\nI had a pleasant experience.\nMy skin has now a glow and feels tighter.",
"languageCode": "en"
},
"authorAttribution": {
"displayName": "Nina Promintos",
"uri": "https://www.google.com/maps/contrib/111138478969449042780/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocJharC68FHbx6xYNN6M-aZLBnKXU0nxv_FprijNHZVyEd-pqw=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2024-10-08T09:02:26.056182Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=ChZDSUhNMG9nS0VJQ0FnSURudGVLSWR3EAE&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sChZDSUhNMG9nS0VJQ0FnSURudGVLSWR3EAE!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
},
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/Ci9DQUlRQUNvZENodHljRjlvT2w5eVNYSmZkREYxV0haeWJqbFVWM050VkhOVE9IYxAB",
"relativePublishTimeDescription": "a month ago",
"rating": 5,
"text": {
"text": "Complaints about edema aren't always understood or taken seriously everywhere. But here, you certainly feel heard and seen. Luna and Julia are very friendly and work calmly and professionally.\nThey're very pleasant to chat with throughout the treatment (which can be quite sensitive), making it easier to relax in a pleasant atmosphere.",
"languageCode": "en-US"
},
"originalText": {
"text": "Klachten rondom oedeem worden niet altijd overal begrepen of serieus genomen. Maar hier voel je je iig gehoord en gezien. Luna en Julia zijn zeer vriendelijk en werken rustig en professioneel.\nKletsen je heel fijn door de behandeling heen (die best wel gevoelig kan zijn) waardoor het makkelijker is je te ontspannen in een prettige sfeer.",
"languageCode": "nl"
},
"authorAttribution": {
"displayName": "Marieke Hooyenga-van de Vaart",
"uri": "https://www.google.com/maps/contrib/117412472654758489905/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocLGv6Hsn-tEzoPf6_lVJr3AqpjXeyKTdlQZl6jgq2iyq9kqDA=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2026-02-10T08:52:40.144698886Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=Ci9DQUlRQUNvZENodHljRjlvT2w5eVNYSmZkREYxV0haeWJqbFVWM050VkhOVE9IYxAB&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sCi9DQUlRQUNvZENodHljRjlvT2w5eVNYSmZkREYxV0haeWJqbFVWM050VkhOVE9IYxAB!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
},
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/Ci9DQUlRQUNvZENodHljRjlvT210aVV6VmxOemhwVGtONGMwbG1kSFJ0YjFOMmMzYxAB",
"relativePublishTimeDescription": "a month ago",
"rating": 5,
"text": {
"text": "Julia is very friendly and helped me skillfully and professionally.",
"languageCode": "en-US"
},
"originalText": {
"text": "Julia is erg aanrdig en heeft mij kundig en professioneel geholpen.",
"languageCode": "nl"
},
"authorAttribution": {
"displayName": "Margreet",
"uri": "https://www.google.com/maps/contrib/107982904946390074645/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocI7gwhsNlqjP7X7xmtQ_HuY5mmEZGT3QxBlJ6h8bxoA_T7I6Q=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2026-01-24T09:35:58.887273153Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=Ci9DQUlRQUNvZENodHljRjlvT210aVV6VmxOemhwVGtONGMwbG1kSFJ0YjFOMmMzYxAB&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sCi9DQUlRQUNvZENodHljRjlvT210aVV6VmxOemhwVGtONGMwbG1kSFJ0YjFOMmMzYxAB!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
},
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/ChZDSUhNMG9nS0VJQ0FnSUNEa3NYcVZREAE",
"relativePublishTimeDescription": "a year ago",
"rating": 5,
"text": {
"text": "Shivani helped me very professionally. I was really hesitant about the treatment, but Shivani really took the time to explain everything to me. This helped me better understand the options available to me. This allowed me to make the right choice, taking my wishes and budget into account.",
"languageCode": "en-US"
},
"originalText": {
"text": "Ik ben heel professioneel geholpen door Shivani. Ik was echt aan het twijfellen over de behandeling maar Shivani heeft echt de tijd genomen om me alles goed uit te leggen. Hierdoor begreep ik beter\nwat mogenlijkheden voor mij zijn. Ik heb zo de juiste keuze kunnen maken rekening houdend met mijn wensen en budget.",
"languageCode": "nl"
},
"authorAttribution": {
"displayName": "Mina Koendan",
"uri": "https://www.google.com/maps/contrib/108801267209626612458/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocJky-yyE6aEuKyZVRO-WRXQhWn0hBHK0d9hD5eCx99T384m4w=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2024-03-26T09:15:14.865699Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=ChZDSUhNMG9nS0VJQ0FnSUNEa3NYcVZREAE&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sChZDSUhNMG9nS0VJQ0FnSUNEa3NYcVZREAE!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
},
{
"name": "places/ChIJGcDVwC7JxUcRumA7QB26xqU/reviews/ChZDSUhNMG9nS0VJQ0FnTUR3b2FYZkdREAE",
"relativePublishTimeDescription": "11 months ago",
"rating": 5,
"text": {
"text": "I've been at the skin clinic for a few weeks now, and I can only say that it's very friendly.\nAnd Shivanni is super friendly.\nAnd very knowledgeable.\nShe takes you seriously, and is always very pleasant and welcoming.\nKind regards, Loes",
"languageCode": "en-US"
},
"originalText": {
"text": "Ik ben sinds een aantal weken bij de huid kliniek, en kan niet anders zeggen dat het er heel vriendelijk aan toe gaat\nEn shivanni is super vriendelijk.\nEn heel kundig.\nNeemt je seriues, en altijd heel fijn en gezellig.\nVriendelijke groet Loes",
"languageCode": "nl"
},
"authorAttribution": {
"displayName": "Loes",
"uri": "https://www.google.com/maps/contrib/107112285795087856750/reviews",
"photoUri": "https://lh3.googleusercontent.com/a/ACg8ocKG89HgArZdH-E7Ut_D6ewK7-KbgItOJDCjTENhIc5mmBCOCy8=s128-c0x00000000-cc-rp-mo"
},
"publishTime": "2025-03-26T15:45:37.419093Z",
"flagContentUri": "https://www.google.com/local/content/rap/report?postId=ChZDSUhNMG9nS0VJQ0FnTUR3b2FYZkdREAE&d=17924085&t=1",
"googleMapsUri": "https://www.google.com/maps/reviews/data=!4m6!14m5!1m4!2m3!1sChZDSUhNMG9nS0VJQ0FnTUR3b2FYZkdREAE!2m1!1s0x47c5c92ec0d5c019:0xa5c6ba1d403b60ba"
}
]
}
]