Save API call with Lists

Need help
1

Hello all,

I’ve seen multiple threads about saving API JSON stuff with Lists but still trying to understand the Structure and Workflow please…

The API call structure returns like that :

grids (list)
	product id		number
	product label	text	

	events (list)
		eventId			number
		result			text

		outcomes (list)
			label		text
			order		number

We have 3 different List and the last two are kind of inside the first one.

Hence, does it mean that I have to build three different Table in the Database ?

I was able to retrieve and save the items from the grids List and the Events List but with two different API Workflow :
Capture d’écran 2024-05-06 à 10.54.21

is it the way to go ? I guess I need something else to link both of them and make the relationship in the Database.

Thank you for your help :slight_smile:

Armand

2

Willing to write a fully documented Mini Guide when I know the process so would be useful to everyone here :slight_smile:

3

This topic was automatically closed after 70 days. New replies are no longer allowed.