syndesisio / syndesis

This project is archived. A flexible, customizable, open source platform that provides core integration capabilities as a service.
https://syndesis.io/
Apache License 2.0
597 stars 203 forks source link

Servicenow - can't retrieve data from custom table #3223

Closed mastepan closed 6 years ago

mastepan commented 6 years ago

This is a...


[ ] Feature request
[ ] Regression (a behavior that used to work and stopped working in a new release)
[ x ] Bug report  
[ ] Documentation issue or request

The problem

If I create a custom table in Servicenow, I can§t select it and therefore retrieve any data in an integration using Servicenow connection.

Expected behavior

I can select and retrieve the data from a custom table in Table Name selectbox.

Screenshot

snrr

Request and Response Data

API Endpoints and Schemas

Tasks involved / Steps to Reproduce

1. 2. 3. 4.

lburgazzoli commented 6 years ago

@mastepan can you add the steps to create the custom table ?

mastepan commented 6 years ago

@lburgazzoli do you have any suspicion I can focus on or do you want me to create step by step instructions to know how to do it?

lburgazzoli commented 6 years ago

I think it is a permission issue so maybe the new table is not accessible by the user used for servicenow connector or it is not accessible via REST service so I'd really like to know what are the steps you performed so I can re-create the issue on my env.

Any help in digging the problem is of course very welcome :)

lburgazzoli commented 6 years ago

@mastepan I did find the issue so let me open a PR

mastepan commented 6 years ago

@lburgazzoli tell me, if you need any more info sn1 sn2 sn3 If I click Explore REST API, it returns response OK 200

mastepan commented 6 years ago

@lburgazzoli I still can't see any user-created table. Any table I create in Servicenow obtains name with "u_" prefix. There are no tables starting with "U" prefix selectable in Retrieve record action

lburgazzoli commented 6 years ago

If you give it a name/label, the name is shown

On Tue, 7 Aug 2018 at 09:58, Martin Stepanek notifications@github.com wrote:

Reopened #3223 https://github.com/syndesisio/syndesis/issues/3223.

— You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub https://github.com/syndesisio/syndesis/issues/3223#event-1774612802, or mute the thread https://github.com/notifications/unsubscribe-auth/AByEhQutws6mR-SNVVAzH3VM6wwVPzpoks5uOUirgaJpZM4VmVLc .

--

Luca Burgazzoli

mastepan commented 6 years ago

@lburgazzoli what do you mean? As far as I can see there is no possibility to create a table without name/label so I think I'm not able to do this wrong.

lburgazzoli commented 6 years ago

I mean that u is the system nane for a user created table but the table may have a human name (don’t remember if it is the label) so it may not be shown as u in the dropdown.

But of course it could be a new bug :)

On Tue, 7 Aug 2018 at 10:07, Martin Stepanek notifications@github.com wrote:

@lburgazzoli https://github.com/lburgazzoli what do you mean? As far as I can see there is no possibility to create a table without name/label so I think I'm not able to do this wrong.

— You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub https://github.com/syndesisio/syndesis/issues/3223#issuecomment-410971412, or mute the thread https://github.com/notifications/unsubscribe-auth/AByEhYWxUAKeq5yKWg1BAH148B-kQUP_ks5uOUq9gaJpZM4VmVLc .

--

Luca Burgazzoli

mastepan commented 6 years ago

@lburgazzoli Ah, yes, There are names and labels. Label can be "My Table" and the name is then e.g. "u_my_table". But all tables have their modified names in the dropdown in syndesis. If the name is a_b_c then the shown name in the dropdown is "A B C" which looks like label. This might have confused you.

Therefore a shown name of a user-created table should be "U tableName" But there is no such name in the dropdown. There isn't even "tableName".

It's a bit complicated to explain...

lburgazzoli commented 6 years ago

let’s have a blue jeans this afternoon ok ?

On Tue, 7 Aug 2018 at 10:24, Martin Stepanek notifications@github.com wrote:

@lburgazzoli https://github.com/lburgazzoli Ah, yes, There are names and labels. Label can be "My Table" and the name is then e.g. "u_my_table". But all tables have their modified names in the dropdown in syndesis. If the name is a_b_c then the shown name in the dropdown is "A B C" which looks like label. This might have confused you.

Therefore a shown name of a user-created table should be "U tableName" But there is no such name in the dropdown. There isn't even "tableName".

It's a bit complicated to explain...

— You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub https://github.com/syndesisio/syndesis/issues/3223#issuecomment-410976153, or mute the thread https://github.com/notifications/unsubscribe-auth/AByEhXgszbB-9VysGimcNTpXm5Ve7Ia1ks5uOU6_gaJpZM4VmVLc .

--

Luca Burgazzoli

mastepan commented 6 years ago

Ok. Ping me on IRC. I'm available till 3:30 PM (GMT+2)

Martin Stepanek FUSE Quality Engineering Red Hat - Brno office

----- Original Message ----- From: "Luca Burgazzoli" notifications@github.com To: "syndesisio/syndesis" syndesis@noreply.github.com Cc: "Martin Stepanek" mastepan@redhat.com, "State change" state_change@noreply.github.com Sent: Tuesday, August 7, 2018 10:30:11 AM Subject: Re: [syndesisio/syndesis] Servicenow - can't retrieve data from custom table (#3223)

let’s have a blue jeans this afternoon ok ?

On Tue, 7 Aug 2018 at 10:24, Martin Stepanek notifications@github.com wrote:

@lburgazzoli https://github.com/lburgazzoli Ah, yes, There are names and labels. Label can be "My Table" and the name is then e.g. "u_my_table". But all tables have their modified names in the dropdown in syndesis. If the name is a_b_c then the shown name in the dropdown is "A B C" which looks like label. This might have confused you.

Therefore a shown name of a user-created table should be "U tableName" But there is no such name in the dropdown. There isn't even "tableName".

It's a bit complicated to explain...

— You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub https://github.com/syndesisio/syndesis/issues/3223#issuecomment-410976153, or mute the thread https://github.com/notifications/unsubscribe-auth/AByEhXgszbB-9VysGimcNTpXm5Ve7Ia1ks5uOU6_gaJpZM4VmVLc .

--

Luca Burgazzoli

-- You are receiving this because you modified the open/close state. Reply to this email directly or view it on GitHub: https://github.com/syndesisio/syndesis/issues/3223#issuecomment-410977668

mastepan commented 6 years ago

The problem was that my table extended Import set table that is filtered out of the list. Thanks Luca!