Hello, I am having issues connecting to SNOW production environment using the ServiceNow Connector created by @Cristian_Negulescu. I created a query to get task data. I entered the consumer key, consumer secret, username and password set up for prod in the properties panel, but when I try to run the command I get this:
System.FormatException: The format of value ‘’ is invalid.
at System.Net.Http.Headers.HttpHeaderParser.ParseValue(String value, Object storeValue, Int32& index)
at System.Net.Http.Headers.HttpHeaders.ParseAndAddValue(String name, HeaderStoreItemInfo info, String value)
at System.Net.Http.Headers.HttpHeaders.Add(String name, String value)
However when I changed the environment to Design and test with the same URL and click the Test connection button the query works. Why does it work after I press the test connection button, but not before?
All the Authentication Production values are use only when the environment is Set to Production and all the wizards are disable/ not working. This values will be use exclusive for the Robot on the runtime.
If you want to test something from the Studio in production witch is not recommended you need to put your production details on the Authentication Design. To be sure that your server is Ready please check this videos for all the configuration that you need to do on ServiceNow:
If you want to move from Design to production please follow this video for details:
I think you need to do this Steps to understand exactly what is your problem:
1. put all the connection value for Your production Server on the Authentication Design and set the Environment for Design and test. Go and Studio on Get wizard Design or Get Wizard SQL and run your command.
2. If Step 1 work OK please run the robot with all the configuration value remain the same and see if you have the same result in datatable.
3. Move all the configuration to Authentication Production and change again the Environment to Production and run the robot and see what you get on datatable result.
If you get error only on the Step 3 please give me the SQL command to understand what you interrogate and test on my instance.
The connection worked after adding the consumer key and consumer secret! I have another issue now pulling in user data from the sys_user table. If the user is inactive it will return no data, but if the user is active it will return the data. Any idea why it cannot pull that information if they are inactive. When I manually signed in with the account I am able to see the user’s data if they are inactive so it is not because they don’t have access to view inactive users.
When you say Dev and Production you mean that you have 2 different instance of ServiceNow? If this is true maybe you have other difference on configuration between the 2 platforms.
For me as a developer the difference between Test and Development and Production Authentication is that in case of Prod Authentication I convert internally all data from SecureString to String, the rest of commands are the same. So only think that I can image is that you have difference between your 2 system Dev and Production.
Please run the Step 2 from the last answer on your production system and see if is working.
Yes that is correct. We have two instances of ServiceNow. The configurations are set up the same way for the SN account so its not that the account doesn’t have authorities to view inactive users.
I have tried #2 and the same issue happens. I have a test user that is marked as inactive and it returns no data, but as soon as I change that test account to active and run the automation again it is able to find and retrieve the data.
Sorry for the delay in answering I was on vacation. So the answer is Yes if you use Get User List the default command is getting only the active users please check the picture attached where is say Active true in the SQL.
Hi Cristian thank you for getting back to me. I tried running a query where active = false and it still does not return any inactive users. I ran the inactive query against our DEV instance. Then had a ServiceNow representative run the same query. It did not return any values for me, but returned values for them. Could it be that the API call only allows calls for active users?
There is strange situation that I will analyze, also in my instance when I run with active false I get NO DATA. Until I will understand exactly what is wrong here is a solution for you. Run SQL like this without WHERE and LIMIT.
SELECT name, user_name, first_name, last_name, email, sys_id, active FROM sys_user
That query returns 10,000 items. I then print out the data table and row count with this workflow:
When I run this workflow it returns a count of 0 and an empty data table:
For some reason it is not storing the data from the query into the data table. Could it be because data it is trying to store is too large? Is there a limit to how much the data table can store in UiPath?
I try on my System to run the Robot in Production and the Get Data Wizard SQL is returning Data without any Issue.
If you are in Production all the WIZARD from UiPath Studio won’t work. If you are in Design AND Testing all the wizards will work, but before trying to do something you need to click the Test Connection button and this connection will be valid 1 hour.
Here I have some movies on how to change from Design to Production:
If you still have this issue try to update to the latest version and tell me step by step what are you doing.