# Sourcing multiple tables of data from an API **URL:** \ **Category:** Ask for Help\ **Created:** [October 26, 2023, 1:56am UTC](https://community.glideapps.com/t/sourcing-multiple-tables-of-data-from-an-api/67298 "2023-10-26T01:56:23Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 26, 2023, 8:06am UTC](https://community.glideapps.com/t/sourcing-multiple-tables-of-data-from-an-api/67298/2 "2023-10-26T08:06:39Z")
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. > [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766): > > I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc) --- _[View the full topic](https://community.glideapps.com/t/sourcing-multiple-tables-of-data-from-an-api/67298)._