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
Hi Anonymous ,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as a "Accept as solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.