# Error from Workday SSIS connector extention question **URL:** \ **Category:** CData Drivers\ **Tags:** question, ssis, workday\ **Created:** [March 15, 2024, 1:07pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector-extention-question/666 "2024-03-15T13:07:00Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Renukachari\_Kasee](https://avatars.discourse-cdn.com/v4/letter/r/ecccb3/32.png) [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Post date:** [March 15, 2024, 1:07pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector-extention-question/666/1 "2024-03-15T13:07:00Z")
Hi Ethem, thanks for your replay, i have updated the latest drivers in my system. after that i can see the WQL extension objects. all objects i can see but however i am seeing some more problem in this query i am attaching error image for your reference. and also one more is, please suggest how to get all the objects listed in workday, same like in sql server usually SELECT \* FROM information\_schema.Tables sintax used to get all objects similar kind of thing any sintax is it available in Workday? kidnly advise. ![df96260b-aad6-4aec-9006-d94b34bf9f20.png](https://us1.discourse-cdn.com/cdata/original/1X/b71147d14b22451abb9245c302ef44809815fc89.png) ![2de4b21b-c3b8-4cd6-990f-829cac74355d.png](https://us1.discourse-cdn.com/cdata/original/1X/f95e042d03518db92f951ab2de5ad949fb0eaf28.png) ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [March 15, 2024, 6:24pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector-extention-question/666/2 "2024-03-15T18:24:17Z")
HI  @Renukachari_Kasee The “_Received error from Workday: Invalid WQL query: The entered information does not meet the restrictions defined for this field_” is a generic error message coming from Workday that can be thrown due to various reasons. One cause that comes to mind is that in your case the IN clause is not being honored for the company\_prompt field. This can happen since company\_prompt is a single-value prompt. Can you try setting the _'SplitSingleValuePrompts_’ property to True in your connection configuration and see if anything changes for you? Another reason might be lack of permissions to access data for certain company\_Prompts. Also, are you able to get data when you specify a single company\_Prompt where the company\_Prompt is a workdayId that you can access as in the following example? ```auto SELECT * FROM AdHocPayments WHERE company_Prompt='..........' ``` Note that the company.Descriptor does not match the company\_prompt. The format of the company\_Prompt value is that of an ID, more specifically it matches with the values returned for the workdayId column. Keep in mind that you will also need to ensure that you have the correct permissions to access the data for all company\_Prompts if you want to use the original query so you will need to double-check with your Workday Admin on that. In case any of the above does not help, the next best course of action would be to enable logging by setting the Logfile and Verbosity properties, in order to determine how the query is being sent and what exactly triggers the error with the Invalid WQL query. The logs will definitely provide more context on the issue. To enable logging set Logfile to a file path where the logfile will be written to (ex Logfile=C:/Users/Public/CDataWorkday.txt) and Verbosity=3.That said, I would invite you to submit a ticket with our support team [https://www.cdata.com/support/submit.aspx](https://www.cdata.com/support/submit.aspx) with the details of the issue and after that someone from our support team will follow up with a secure link where you can upload the logfile. As for the second inquiry, we do expose certain system tables that will give you schema information as well as details on all the tables and views existing in Workday. To get a list of all the tables and views you can use the following: ```auto SELECT * FROM sys_tables ``` If you want to get additional information like the name of the columns and other details for each table you can run a query as follows: ```auto SELECT * FROM sys_tablecolumns WHERE TableName='....' ``` You can read more about the system tables here: [CData SSIS Components for Workday - System Tables](https://cdn.cdata.com/help/JWJ/rssis/pg_allsystables.htm) ---
**Author:** ![Renukachari\_Kasee](https://avatars.discourse-cdn.com/v4/letter/r/ecccb3/32.png) [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Post date:** [March 15, 2024, 7:58pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector-extention-question/666/3 "2024-03-15T19:58:11Z")
Hi Ethem, thanks for your response, i have a admin level of access however i have followed as you suggested, kindly check the below screenshot now i am getting http protocol error. kindly advise. ![a6afb198-176d-4e16-a9c5-f71d23888517.png](https://us1.discourse-cdn.com/cdata/original/2X/b/b7cc38e4c9662974a1428c24329a8f0c62d69bb0.png) Below screenshot kind of popup will allow me to view the report in workday but coming to ssis cdata drivers its throughing an error. please suggest ![d4ff44a1-7df5-4541-a72c-69899a72f83d.png](https://us1.discourse-cdn.com/cdata/original/2X/e/e9985c6269a996ef7c6ed14b18f3c30b5f36935d.png) thanks, Renukachari kasee Redwood Software inc ---
**Author:** ![LaurenH](https://avatars.discourse-cdn.com/v4/letter/l/ecae2f/32.png) [@LaurenH](https://community.cdata.com/u/LaurenH)\ **Post date:** [March 20, 2024, 6:56pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector-extention-question/666/4 "2024-03-20T18:56:12Z")
Hi @Renukachari_Kasee  I wanted to reach out to you here on the community page as I have had issues reaching you at your @redwood.com email. Do you have an alternate email I can reach out to you with to further discuss the Zendesk SSIS component issue you are encountering? Thank you!