Forum Discussion
API Pagination Assistance
Hi ,
Some columns contain Lists, but transformations assume they are Text.
So try using Text.Combine to convert lists to text before applying transformations.
Paginated results include incompatible types (e.g., Lists) during combination.
So Convert all results to tables using Table.FromList before combining them with Table.Combine.
Apply Table.FromList wherever the API response is generating a List instead of a Table.
Apply Text.Combine after loading the data from the API and before performing transformations that expect Text values
Furtehr go through applied steps to get understanding where these arer happening
Where should I add the Table.FromList to the script? I fiddled around with adding it in a few places and I wasn't successful getting it to work.
Super UserApply Table.FromList wherever the API response is generating a List instead of a Table.
Apply Text.Combine after loading the data from the API and before performing transformations that expect Text values
Furtehr go through applied steps to get understanding where these arer happening