Need assistance with JSON data structure creation

Hi and welcome to the callin.io Community!

What are you receiving as input and what are you getting as output, and what are you anticipating?

L

Hi, thanks for the response!

Input:

From Airtable I’m getting these fields:

• URL for video ({{28.url}})
• Video dimensions ({{56.outputwidth}} and {{56.outputheight}})
• Text for headline ({{56.hooks}})
• Text for lower third ({{56.calltoactions}})

Current Output:

When I try to create a data structure in the JSON module using my template, it only generates options for the video element:

json
{
“elements”: [
{
“src”: “video_url”,
“type”: “video”,
“zoom”: 0,
“width”: 1920,
“height”: 1080,
“duration”: -1,
“position”: “center-center”
}
]
}


Expected Output:

I need both the video element AND the CNN-style component in the structure:

json
{
“elements”: [
{
“src”: “video_url”,
“type”: “video”,
“zoom”: 0,
“width”: 1920,
“height”: 1080,
“duration”: -1,
“position”: “center-center”
},
{
“type”: “component”,
“component”: “basic/050”,
“settings”: {
“card”: {
“vertical-align”: “bottom”
},
“headline”: {
“text”: “headline_text”,
“font-size”: “auto”
},
“lead”: {
“text”: “lead_text”,
“font-size”: “auto”
}
},
“start”: 3
}
]
}


The JSON module seems to ignore the second element (component) when generating the data structure. Do I need to handle this differently, perhaps with separate JSON modules?

Hello,

I'm interested to know why you're retrieving the URL from the iterator rather than the Airtable data. This might shed light on the issue. Have you attempted to use all the data from the iterator (28) instead of Airtable?

I'm quite confident that the JSON parser is capable of handling more intricate JSON structures than the one you've shown. Therefore, I'm not convinced that's the root cause.

If you're not achieving the desired outcomes, please provide the following information in a follow-up:

• The input and output bundles for the different modules.
• An export of your scenario blueprint. You can achieve this by clicking the three buttons at the bottom of your scenario and selecting "export blueprint." Please attach it to your response.

Thanks

Hi,

Thanks for your assistance. If you were to take the precise JSON structure I shared initially and paste it into the “Create JSON Module” under the “generate” option, you'll notice that only the initial segment is produced, irrespective of any connections.

Understood.

Could you explore an alternative method? For instance, you might consider creating three separate collections instead of an array of collections. Afterward, you could utilize a text aggregator to reconstruct the JSON format you require.

Alternatively, could you manage the process using only text, ensuring it's correctly formatted as JSON? While this approach requires more manual effort, it offers greater control.

Thanks, I just had time to test. I ran with the first scenario. Here is the flow that worked

“Create Json Module” → Data Structure: Two Collections (Video and Component Element)

→ “Parse Json Module” → “Text Aggregator Module” → “Parse Json Module”

Marking your response as the solution. Thanks!