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';


      RestConnectorMasterTable:

      SQL SELECT

      "__KEY_root",

      (SELECT

      "field1",

      "field2",

      "__FK_data"

      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?