2 Replies Latest reply: Jan 23, 2018 4:36 AM by Sandeep Roy RSS

    REST Connector error using WITH CONNECTION and Pagination

    Jean Paul Neumann

      I'm trying to access an API, using REST Connector, including 'WITH CONNECTION (URL "https: // ...")' after SELECT. I need to do pagination. This way I configure the 'pagination type = NextUrl'. Also use the 'Next Url Field Path' parameter.


      LIB CONNECT TO 'MyConnection';








      FROM "data" FK "__FK_data")

      FROM JSON (wrap on) "root" PK "__KEY_root";

      WITH CONNECTION(URL "https://....");


      When I run Script, I get the following message:

      "Connector reply error: You cannot use the selected pagination type and the 'WITH CONNECTION' statement at the same time. Please set 'Pagination type' to None on the connection dialog."

      How do I use pagination using WITH CONNECTION?