Hi All,
I am having an issue with my workflow.
I have a scheduled Webhook running a GET request on a daily basis:
It is pulling back data in the following format, where ID, is my Customer ID, then there is an array of Contract Data for each customer, please see below:
[
{
"ID": 288,
"Contracts": [
{
"ID": 1634,
"Name": "Test1",
"StartDate": "2025-10-01",
"EndDate": "2026-09-30",
"ContractNo": "",
"Expired": false
}
]
},
{
"ID": 292,
"Contracts": [
{
"ID": 1403,
"Name": "Test2A",
"StartDate": "2025-06-01",
"EndDate": "2026-05-31",
"ContractNo": "292/001",
"Expired": false
},
{
"ID": 1238,
"Name": "Test2B",
"StartDate": "2025-08-01",
"EndDate": "2026-07-31",
"ContractNo": "292/002",
"Expired": false
},
{
"ID": 1577,
"Name": "Test2C",
"StartDate": "2025-10-01",
"EndDate": "2026-03-31",
"ContractNo": "292/003",
"Expired": false
}
]
}
]The problem that I am having is as follows:
For each customer where there is only one Contract, I get a row added to my table as expected.
Where there are multiple Contracts, in the example above (Test2A, Test2B, Test2C), there are 3 rows created (which are, oddly to me, not consecutive). Each row has all of the correct details in the correct columns with the exception of my contract names; where all three are repeated for each row, as shown below:
The loop configuration is shown below:
Could anybody point out where I am going wrong?
