eduva
Scholar

Query Excel Services Authorization Error

Hi, I am trying to create list items in Sharepoint 2013 using a Excel Workbook. My plan was to follow this example, saving each column of my worksheet in a collection variable and create a new item list for each loop. 

Before going into details with my error, I would also like to know if it is possible to allow the user to choose an excel workbook they uploaded to a document library in an infopath form and save the workbook path to use in the Query Excel Services action?

While I was configuring the very first Query Excel Service action I got multiple Status 401 Unauthorized errors. I was using my own windows username and password (since our site is a company site and all users have company laptops).

Thing is, there are times where I can execute the action and I get my values but there are times where I just get the same 401 error. I am worried that if I continue working and launch the workflow the users will have the same fate, it working some times and then throwing errors. 

When I just wrote my username and password I got errors only but then I went and created a credential constant in Manage Constant under the Nintex Workflow Manangement in site settings as detailed by Kapil Joshi here and it started to work occasionally as I detailed before.

I am obviously doing something wrong here. 

I cant access the Central Administration, I am just an employee that thought of using Nintex - Sharepoint to automate some processes. 

0 Kudos
Reply
1 Reply
eduva
Scholar

Re: Query Excel Services Authorization Error

No input for this? I still need help, please.

0 Kudos
Reply