Forum Discussion

gotmike's avatar
gotmike
Frequent Visitor
10 years ago

how to create a query that paginates?

I'm working with the Hubspot CRM API and when you query for a list of all deals, you only get 100 records at a time, and they want you to send subsequent queries with an "offset" to paginate the resu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Instead of having them all listed in one query, could you please have them created as indicated by me i.e., to create 3 queries and give it a try?

 

Regards,

A!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

I have created different queries and it almost works now.

 

Unfortunately another problem has emerged.

I have extracted a customfield of the query and i got a failure.

"Expression Error: Value "null" cannot be converted to Typ List.

Details:

Value=

Type=[Type]

= Table.TransformColumns(#"Erweiterte Column1.fields.customfield_13101", {"Column1.fields.customfield_13100", each Text.Combine(List.Transform(_, Text.From)), type text})

Do have an idea how to solve it?

 

Thanks alot!

freiburgc