I want to integrate my table request of bigquery in APIGEE API proxy.
I create an integration and a collector for my table in google cloud, I connected the APIGEE proxy to connector.
It works APIGEE response me with data of table, but with a problem, the list have a maxinum of 200 items(are more result). I tryed to make a multiple pages logic, but I found a problem.
The connector used for bigquery have an output parameter called "listEntitiesNextPageToken" that should contains the token of next page, but effectively remain the default value after run.
I search everywhere but all documentation of this parameter is this ("https://cloud.google.com/apigee/docs/api-platform/integration/connectors-task")
Solved! Go to Solution.
I solved using Call REST endpoint task instead Connector task.
This task not require a cicle to obtain all results, but require 2 REST call:
-first create a job
-second obtain the result of the query into the job
I think you will need to string together a couple of tasks to meet this use case. Assuming you are going to trigger this from Apigee,
Please remember we have a 8MB data size limit when fetching data from sources.
I tried, but "listEntitiesNextPageToken" mantain the default value(empty) after connector run, the cicle return me the same result every time.
And data are smaller than 8MB.
Is it possible there aren't more than 200 records to fetch?
Results are more than 200 rows.
Can APIGEE evaluetion limit the function?
I solved using Call REST endpoint task instead Connector task.
This task not require a cicle to obtain all results, but require 2 REST call:
-first create a job
-second obtain the result of the query into the job