How to obtain missing JSON fields/info?

:bullseye: What is your goal?

I have a scenario with 3 modules.

  1. Webhook: custom webhook (obtaining JSON from source data)
  2. JSON: parse JSON
  3. Airtable: create record

It works and is successful all the way through the 3 modules, but it is missing data/fields. An important topic is that there are multiple data fields with the same name and 3 groups (example- name 1, name 2, name 3. and website 1, website 2, website 3. group 1 in the source data has name 1 and website 1 which go together in a group, and name 2 and website 2 go together in a group, and same for name/website 3.).

When I go in the airtable module to map the fields, it lets me see/map only ONE name and only ONE website. So, name/website 2 and 3 are not visible to be mapped. Therefore, the result in airtable is that name/website 1 lands in airtable and name/website 2 and 3 do not land in airtable.

I temporarily unlinked module 2 and 3 to test/get module 1-2 working, but all 3 were initially connected and working (other than missing the additional data).

I am new to make.com and simple language and easy to follow instructions would be greatly appreciated. Anyone solved this? And, @benjamin_from_make, I noticed you helped on a similar issue that @Nasiba_Alieva posted previously, and would love your help as well (note sure if the tag will work) or other make.com team member and those experienced in the community. @Nasiba_Alieva, any chance you may know as well?

Thanks so very much.

:thinking: What is the problem & what have you tried?

Details above

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Hello! Welcome to the community!

Can you please show us an example of the JSON document you receive, and the way you map in Airtable? So that we fully understand the format of the data you get?

Thank you.

Ben

@Brenda let me send you a direct message, and let’s get back to this thread when we have the issue fixed :slightly_smiling_face:

Hey Brenda,

sounds like you have an array of items, in which case Make only shows the first item of the array so you can see the structure.

You can still access the rest of the items using their order index or using the map() function to dynamically find them.

Can you show a screenshot of the JSON or paste it here to check so we can confirm this?

Can you also show the configuration of the Airtable module and what you need mapped where?

2 Likes

Hi @Stoyan_Vatov, I had a look from a doc I got in private, and that’s exactly what you said. an array of items that needed an index for some of the mappings.

Thanks!