How to Execute SAP Query and get its Result in UiPath

would be very useful for my process this package!
my problem that i use single sign on and not username and password…
it’s possible to use single sign on?

thank you

Loris

@l.sambinelli

Hello Loris,

yes, it is possible, but I have never tried that. You can find more information in the technical documentation of NCo.

Best regards
Stefan

@l.sambinelli

Hello Loris,

I have updated the package above with the possibility to use, instead of user and password, an SSO ticket. I don’t have the possibility to try that. Please check if it works and let me know your results.

Best regards
Stefan

1 Like

Hello Stefan!
i would like to use this app but i never used an SSO ticket.
In my company i use SS0 without ticket
actually i use this settings
image

so,
i don’t know how to connect with ticket. do you have some guide? i searched online but i can’t find any right guide

1 Like

@l.sambinelli

Hello Loris,

I will extend my library with all these parameters and update it shortly.

Also I will delete the SSO ticket parameter, because as an external application it is quite difficult to get an SSO ticket, only as an RFC server program. Of course, this is not very handy.
Thank you very much to let me know this. But as I wrote above, I never use SSO and I don’t have the possibility to try that.

Best regards
Stefan

Hello Stefan,
if you add the SSO i will happy to test it for you!

1 Like

@l.sambinelli

Hello Loris,
thanks for the reply, the package is updated.

I added now an SNC parameter section, if you now add

SNCMode = “1”
SNCSSO = “1”
SQNQOP = “9”

it should work like in your example. All parameters are string type.

image

Thanks and best regards
Stefan

1 Like

works perfectly!!! great work! !!!

1 Like

Thank you very much for your support Loris. :+1:

Hello Stefan!
i update for your code.
Strange case.

I receive from a query this error:

“Index was outside the bounds of the array.”

i dont’ undertand the error.
do you know what is the solution?

@l.sambinelli

Hello Loris,
thanks for your post.
Could it be possible that the content of one of the fields of your SAP Query contains a comma (,) or a semicolon (;)? E.g. a text field like this “This is a test, with a form; and more.”
Best regards
Stefan

Hi!
this is the result from query

there isn’t any comma or semicolon

Hello Loris,
you have empty fields, which has the content 000:
After splitting at the colon Values[1] must fail, because there is no value.
I have corrected this and there is a new version available above. Thank you very much for this hint.
Best regards
Stefan

Thanks!I’ll try it and let you know

1 Like

now works wonderfully!

Thanks

1 Like

Thank you very much for your support Loris. :+1:

Hello STefan,
I would like to ask you if it would be possible to receive not the technical name sap (ex kna1-kunnr) but its description (ex customer name).
If it were possible, this would avoid having to rename all the columns afterwards.
thanks

Loris

1 Like

@l.sambinelli

Hello Loris,
thanks for your suggestion.
I have added the flag TechnicalFieldName, if it is set True it delivers the technical field names …

image

image

… otherwise the field text.

image

image

Please try it and let me know your results, in particular I am interested in the language of the field text. In my case I set to English but German was returned.

There is a new version available above.
Best regards
Stefan

Hello Stefan!
in my case i receive in my language (italian)
Thanks !

for the settings i leave blank the language field
image

1 Like

Thank you very much for your support Loris. :+1:

1 Like