Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2545

Importing REST service gives a string instead of a boolean to a procedural parameter

XMLWordPrintable

    • Hide

      Using the REST service http://www.telize.com/geoip the following transformation gives the above error:

      BEGIN
      DECLARE STRING VARIABLES.qp = '';
      SELECT A.country_code AS country_code FROM (EXEC SourceModel.invokeHttp(action => 'GET', endpoint => VARIABLES.qp, stream => TRUE)) AS f, XMLTABLE('/response' PASSING JSONTOXML('response', f.result) COLUMNS country_code string PATH 'country_code/text()') AS A;
      END

      Show
      Import REST service using wizard In the Transformation Editor add a quote before /respons' in the Transformation parameter (this is fixed but not released, https://github.com/Teiid-Designer/teiid-designer/commit/752e717ea4c31df1b94e2d57f2a12a42fdbdd210 ) The following error is shown now: ERROR: org.teiid.runtime.client.TeiidClientException: TEIID30145 Unable to convert procedural parameter SourceModel.invokeHttp.stream of type string to expected type boolean Using the REST service http://www.telize.com/geoip the following transformation gives the above error: BEGIN DECLARE STRING VARIABLES.qp = ''; SELECT A.country_code AS country_code FROM (EXEC SourceModel.invokeHttp(action => 'GET', endpoint => VARIABLES.qp, stream => TRUE)) AS f, XMLTABLE('/response' PASSING JSONTOXML('response', f.result) COLUMNS country_code string PATH 'country_code/text()') AS A; END

      After importing a REST service an error is given in the Transformation Editor: TEIID30145 Unable to convert procedural parameter SourceModel.invokeHttp.stream of type string to expected type boolean
      This is because there are quotes around TRUE for the stream parameter and these should be removed.

            rhn-engineering-tejones Edwin Jones
            daan-isaac_jira Daan Creemers (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: