Hi everyone, I'm working on a POC that extracts data from an API,
now whenever I get my data, it results into a collection within a collection (APICollect is the collection, 'd' is a column that contains the 'results' record). As shown:
I believe you can get the row of a collection inside a collection, but in this case, it's 3 layers of collections. I was hoping to extract these set of data only. Tried searching through discussions but wasn't able to find answers and it's making me go crazy!
APICollect is a collection that can contain multiple records and I assume that your API call only returns a single row. Therefore, something on the lines of the following should return your child collection:
LookUp(First(APICollect).d,ID=2) (If the there is an ID column)
Edit: I can see that there is also an extra nested table called results, You can try the following to return the first record of the results table: LookUp(LookUp(LookUp(APICollect,true,d),true,results),true)
You can change ,true, to a condition like ID=2, to retrieve the record that you need. LookUp(LookUp(LookUp(APICollect,true,d),true,results),ID=2) or an other example LookUp(LookUp(LookUp(APICollect,GUID="21321323fdgdfg21321321321",d),true,results),ID=2)