I have set up an ENDPOINT in Matillion (query profile) but I have had terrible success in my orchestration getting more than the 50 rows from my process. Has anyone had success or able to assist with the proper setup?
Hi @HelpEric and welcome to the forums!
There is a limit of 50 for pagination. If you want more you will need to utilise an offset plus an exported parameter. Please see this documentation from Coupa for more information, I hope that helps!
Let us know how you get on! And if anyone has any further suggestions, feel free to post.
Many thanks
Claire