2 Replies Latest reply on Jul 31, 2020 11:35 AM by Yagnik Pandya

    Integrate data from SaaS Provider's basic API

    Cyrus Virdeh Active Member

      Hi,

       

      We are using a cloud based SaaS provider (AuditBoard). They make available data reports that we want to ingest into our data warehouse using IICS Data Integration. The way they make the data available is through a very basic API where the call to get the data is in the form:

      https://serviceURL/api/v1/reports/json?token=usertoken

       

      There is no other authentication (no username/password), no WSDL, or anything else. You simply paste that into a browser addressvthen raw JSON (or a csv file) gets returned. What is the best way to use IICS to integrated this data into a relational database?

      WS Consumer?

      Rest v2?

       

      Any suggestions would be appreciated. Thanks!