01 Apr 2021 15:39:14 Charles Knight posted:
Tricky one to explain but here goes...
Have to use a API Data Source string to obtain results from a database query, I can only add items to the url string to gain more output information from predefined fields.
My challenge is to be able to create, using three API connections a dynamic stock list of items.
First repeat shows the records from the categories API's 'Category' field.
Then I have a nested repeat which shows the records from the SubCategory array which is already inside the Category API connection above, this allows me to select the 'SubCategory' field and, as expected shows the results correctly on the page as;
The actual product details are via another API connection 'MachineList' which I want to appear within the second repeat grouped to that subcategory.
I have tried to use the Data Formatting but it only shows values from the MachineList API and not the SubCategory of the second repeat.
Do I need some sort of variable to hold the value of the SubCategory of the second repeat? If so how do I use that variable, I have tried again in the data formatter for the MachineList connection but it comes back with an error all the time saying it expects a colon.
Sorry in advance if this doesn't make sense, I'm finding it hard to explain let alone implement
Found this tutorial which sort of does what I need to do but of course I can't create a Server Connect query;www.dmxzone.com/go/32997/nesting-database-queries/