Sourcing multiple tables of data from an API

How does each faculty member’s info relate to the ORCID info? Is it through a record ID or something like that? Do you have access to that ID?

If you do, I would think that you can make an API call on the row level, to pull back the information related to each row, by the ID.

Collections are a bit tricky though. Generally, if a record in table A has multiple items related to it, in publications, for example, you would expect multiple records in a table B and a relation from table A to table B to display those records, but that might be hard to do for everyone at once with an API call.

A helper table might be needed here, where you use what we call the Miracle Method to transpose the collection.

1 Like