How to retrieve all data from a JSON file

Questions
1

I have a JSON with the structure below:

[
{
"list": [
	{
	"orderId": "1176593235704-01",
	"creationDate": "2021-11-16T02:53:54.0000000+00:00",
	"clientName": "Amanda Regina Corrente"
	},
	{
	"orderId": "NTS-78005683",
	"creationDate": "2021-11-16T02:51:32.0000000+00:00",
	"clientName": "Carla Ortiz"
	},
	{
	"orderId": "1176592108139-01",
	"creationDate": "2021-11-16T02:35:08.0000000+00:00",
	"clientName": "OZIRIS BO"
	}
]
}
]

I need to retrieve all requests, I’m using http request and then the set component. How should I proceed so that all orders can be retrieved?
all_values_orders

2

Welcome to the community @leandro.alves

Do you want to make an HTTP request per each order? If that is the case, you want to use the Item List Helper node to transform the list array into multiple items. Then, you can reference the Order ID in the HTTP node using expressions.

Let me know if that helps and if you have further questions.

3

Hi there, I set up Http request to pull data from Loyverse and want to record the data on Google Sheet. I cannot do either pulling or record the data from Loyverse. Acctually Http Request got me data, but I can not record it. Any idea?