# Error from Workday SSIS connector **URL:** \ **Category:** CData Drivers\ **Tags:** question, ssis, workday\ **Created:** [March 13, 2024, 8:52pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664 "2024-03-13T20:52:26Z")\ **Posts on this page:** 8\ **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 13, 2024, 8:52pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664/1 "2024-03-13T20:52:26Z")
Hi Team, while connecting Workday Cdata SSIS connector below error is coming kidnly advise. “Invalid FROM clause starting with character: 6405. Invalid WQL syntax.” i am using below query from workday. select \* from creditcardtransactions where “company\_Prompt” = ‘LE020 Redwood Software, Inc.’ ---
**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 14, 2024, 7:58am UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664/2 "2024-03-14T07:58:12Z")
![6826ce21-3920-46fd-9cc2-5b7bfff8bcf5.png](https://us1.discourse-cdn.com/cdata/original/2X/6/67dd170a2ac687f5d87fb5cdcd8587788563fda5.png) In Workday, one prompt is opening while fetch the specific report there we have to select the company so when we pass the just select statement it is stating like above.kindly help me on this ---
**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 14, 2024, 7:59am UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664/3 "2024-03-14T07:59:25Z")
![e5432d3f-8e61-4573-ba2d-91f5b4c82ad2.png](https://us1.discourse-cdn.com/cdata/original/1X/b8ce8f60d0cf084f8f982bf1615b4c936978d3ba.png) if we keep the Where condtion it is throughing an error like above ---
**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 14, 2024, 4:34pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664/4 "2024-03-14T16:34:38Z")
Hi  @Renukachari_Kasee From the screenshots that you have attached in the comments, I suspect you are using an older version of the SSIS Components for Workday. There have been some changes in the v23 version with the Schema organization for the Workday data providers and in the updated version of the Components both AdHocPayments and CreditCardTransactions views fall under the WQL schema instead of the REST schema. That being said, I would recommend you download the updated SSIS Components for Workday in order to be on the most recent version: [https://www.cdata.com/drivers/workday/download/ssis/](https://www.cdata.com/drivers/workday/download/ssis/) Regarding  the error messages that you are facing, I would like to point out that in both cases the problem appears to be stemming from specifying the company\_Prompt. For starters, there is no need to specify a company\_Prompt for CreditCardTransactions as company\_Prompt is not a valid column for this particular table. However, you can filter with workdayID if you want, which you can get from the following query: ```auto SELECT [workdayid], [company.descriptor] FROM [Companies] ``` As for the AdHocPayments view, the company\_Prompt is indeed a required column so you will need to make sure that you specify a valid value for this column. In order to get the company\_Prompts you can use the same query as outlined above: ```auto SELECT [workdayid], [company.descriptor] FROM [Companies] ``` The values returned in the workdayId column can be used as company\_Prompts as in the example below: ```auto SELECT [workdayid], [company.descriptor] FROM [Companies] ``` Alternatively you can run another query in order to get all the data for all company\_Prompts if that is what you want: ```auto SELECT * FROM [adHocPayments] WHERE [company_Prompt] IN (SELECT [workdayid] FROM [Companies]) ``` Feel free to reach out to our support team at [support@cdata.com](mailto:support@cdata.com) in case you have any other questions. ---
**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:44am UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664/5 "2024-03-15T07:44:05Z")
![df96260b-aad6-4aec-9006-d94b34bf9f20.png](https://us1.discourse-cdn.com/cdata/original/1X/b71147d14b22451abb9245c302ef44809815fc89.png) 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. kidnly advise. Thanks, Renukachari Kasee Redwood Software Inc. ---
**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, 8:00am UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664/6 "2024-03-15T08:00:43Z")
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? ---
**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, 8:07am UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664/7 "2024-03-15T08:07:10Z")
![2de4b21b-c3b8-4cd6-990f-829cac74355d.png](https://us1.discourse-cdn.com/cdata/original/1X/f95e042d03518db92f951ab2de5ad949fb0eaf28.png) if i gave company.descriptor then it is prompting like different error ---
**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:42pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664/8 "2024-03-15T18:42:25Z")
I saw you had opened another thread regarding the same issues. To keep our community organized and to provide the most efficient support, I have already addressed your concern in that thread. You can find the detailed response here: > **[Error from Workday SSIS connector extention question | Community](https://community.cdata.com/cdata-drivers-45/error-from-workday-ssis-connector-extention-question-765)** > > 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...