cgivre commented on issue #2792:
URL: https://github.com/apache/drill/issues/2792#issuecomment-1513624108
Hi there,
If you look at your data, you'll see <user id="1" employeeId="1">.
The id and employeeId are attributes of the user tag, so it is expected
behavior to see these fields in the attributes field.
Best,
-- C
> On Apr 18, 2023, at 3:54 AM, oleksandrborniak ***@***.***> wrote:
>
>
> 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>
> <lastLogin>2011-03-19T10:16:00+00:00</lastLogin>
> </user>
> <user id="2">
> <firstName>Jane</firstName>
> <lastName>Doe</lastName>
> ***@***.***</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?
>
>
<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.
>
>
<https://user-images.githubusercontent.com/49722408/232710027-c9520214-47e7-443e-8f60-b9e13028adcd.png>
> —
> Reply to this email directly, view it on GitHub
<https://github.com/apache/drill/issues/2792#issuecomment-1512623385>, or
unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABKB7PQJQXZD747B5XBH3ETXBZCERANCNFSM6AAAAAAW4A7VHE>.
> You are receiving this because you are subscribed to this thread.
>
--
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
