Re: [I] dataPath expression for http-storage-plugin (drill)

[via GitHub]

oleksandrborniak commented on issue #2792:
URL: https://github.com/apache/drill/issues/2792#issuecomment-1512623385

   I tried to use XML version, but it doesn’t work as I expect.
   This is my http config:
   
   ```
   {
     "type": "http",
     "connections": {
       "bamboohr": {
         "url": 
"https://api.bamboohr.com/api/gateway.php/company/v1/meta/users/";,
         "requireTail": false,
         "method": "GET",
         "headers": {
           "Authorization": "Basic  API_KEY",
           "accept": "application/json"
         },
         "authType": "none",
         "inputType": "json",
         "xmlDataLevel": 2,
         "postParameterLocation": "QUERY_STRING",
         "verifySSLCert": true
       }
     },
     "timeout": 15,
     "retryDelay": 1000,
     "proxyType": "direct",
     "authMode": "SHARED_USER",
     "enabled": true
   }
   ```
   
   XML looks like:
   
   ```
   <users>
       <user id="1" employeeId="1">
           <firstName>John</firstName>
           <lastName>Doe</lastName>
           <email>john....@bamboohr.com</email>
           <lastLogin>2011-03-19T10:16:00+00:00</lastLogin>
       </user>
       <user id="2">
           <firstName>Jane</firstName>
           <lastName>Doe</lastName>
           <email>jane....@bamboohr.com</email>
           <lastLogin>2011-08-29T11:17:43+00:00</lastLogin>
       </user>
   </users>
   ```
   
   But I am getting “attributes” column instead of “user id” or “id”.
   Do you have and idea of how I can fix it?
   Or might be we can apply some workaround?
   
   <img width="1052" alt="Screenshot 2023-04-18 at 10 52 30" 
src="https://user-images.githubusercontent.com/49722408/232709810-d70c2599-f49a-461c-a15f-091ae2236c5f.png";>
   
   I can change “xmlDataLevel” from 2 to 1 in http config file, but it doesn’t 
look better.
   
   <img width="1055" alt="Screenshot 2023-04-18 at 10 54 00" 
src="https://user-images.githubusercontent.com/49722408/232710027-c9520214-47e7-443e-8f60-b9e13028adcd.png";>
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org