Uploaded image for project: 'ZZZ-WSO2 Data Services Server'
  1. ZZZ-WSO2 Data Services Server
  2. DS-1234

All attributes not returned on Google Spreadsheet Query mode

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 3.5.1-Beta
    • Fix Version/s: 3.5.1-RC1, 3.5.1
    • Component/s: None
    • Labels:
      None
    • Environment:

      August 29 pack (standalone mode) with jdk 1.8

    • Severity:
      Major
    • Estimated Complexity:
      Moderate
    • Test cases added:
      Yes

      Description

      1. Add Google Spreadsheet datasheet on query mode:

      <data name="sp1privateQ" transports="http https local">
         <config enableOData="false" id="sp1">
            <property name="driverClassName">org.wso2.carbon.dataservices.sql.driver.TDriver</property>
            <property name="url">jdbc:wso2:gspread:filePath=https://docs.google.com/a/wso2.com/spreadsheets/d/11Pgo7HZouoSEo-U2GCltRts2jEgyu-EiWP0AAP_gv3g/edit?usp=sharing;sheetName=testDSS;visibility=private;clientId=1090337626259-7pe5rrj755ippobn69mlbb9riaro0kio.apps.googleusercontent.com;clientSecret=bh4fChtAZNji4s_gjeo_iDfP;refreshToken=1%252FfZ_Eu9iMep0W7lbdaWKuHF60dnV-Vahw5e3u4RiZaXQ</property>
         </config>
         <query id="q1" useConfig="sp1">
            <sql>SELECT Emp_No, Emp_Name, Department, Salary from Sheet1</sql>
            <result element="Emp_No" rowName="Emp_No">
               <element column="Emp_No" name="Emp_No" xsdType="integer"/>
               <attribute column="Emp_Name" name="Emp_Name" xsdType="string"/>
               <attribute column="Department" name="Department" xsdType="string"/>
               <attribute arrayName="null" column="Salary" name="Salary" xsdType="integer"/>
            </result>
         </query>
         <operation name="op1">
            <call-query href="q1"/>
         </operation>
      </data>
      

      Response:

      <Emp_No xmlns="http://ws.wso2.org/dataservice">
         <Emp_No Emp_Name="Kasun Thiwanka" Department="HR"/>
      </Emp_No>
      

        Attachments

          Activity

            People

            • Assignee:
              madhawag@wso2.com Madhawa Gunasekara
              Reporter:
              shashika@wso2.com Shashika Ubhayaratne
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: