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

Details

    • 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

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: