API List Function Assistance

[jcawley]

Good afternoon all,

So I need help configuring a table referencing my API… I cannot get a list of elements to populate! I am receiving the following error:

"Expression.Error: We cannot convert a value of type Record to type Text.
Details:
Value=
379662=379662
396454=396454
396455=396455" ... etc etc

I believe I need to insert a List function (perhaps List.Distinct?), but I am not sure where to plug that into. I'm thinking perhaps part of Table.Transform. Anyhow, the API looks like this:

The function I am using looks like:

And the table:

Any help would be greatly appreciated!

[v-rzhou-msft]

Hi @jcawley 

I found some blogs and I hope they could help you solve your problem.

Blog1: Expression.Error: We cannot convert a value of type Table to type List

Blog2: Expression.Error: We cannot convert a value of type Record to type Text - source is List of records

Blog3: Expression.Error: We cannot convert a value of type Record to type Text.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[mahoneypat]

What happens if you hard code that product # (that looks like a date?) into the url and run that M code as a query instead of a function, so you can see which step causes the error?  I am curious why you are using Record.ToTable, and suspect that is it.  Typically with REST API JSON responses such a step (and the transpose step) is not needed. 

Pat