Forum Academy Marketplace Showcase Pricing Features

API interrogations of data tables

Hi all so I am implementing a gantt chart for some information in my database. I have been told that as the Gantt chart can only interrogate one table I should build a table with all the relevant info in.

I already have all this info in different tables in my app. Can I run a API that runs against these tables and brings the data into its own table to build that info for the Gantt chart system?

If so how?

Thanks

Matt

I am currently looking at something very similar.

So my app calls its own Data API twice in a workflow for different tables.

Then … I am stuck trying to merge the two back to into a single result is hard.

“results”: [
{
“Description”: “Over on another list”,
“Name”: “B1 things” },
{
“Description”: “This is the other list”,
“Name”: “B2 things” }
]
“results”: [
{
“Description”: “A List”,
“Name”: “A1 things” },
{
“Description”: "This is list AA,
“Name”: “A2 things” }
]
What I want is …
“results”: [
{
“Description”: “A List”,
“Name”: “A1 things” },
{
“Description”: "This is list AA,
“Name”: “A2 things” }
{
“Description”: “Over on another list”,
“Name”: “B1 things” },
{
“Description”: “This is the other list”,
“Name”: “B2 things” }

Think I probably need a little bit of scripting to do it :hushed: