SQLSTATE: HY000, Message: At least PARENTTASKID should be specified in this SQL statement.;

Hi Devs,

I am currently using a 3rd party ODBC, and using it to connect on SSIS to perform a data transfer from Asana to my SQL database. When I try to get the subtask table from Asana, I am hitting this error:
SQLSTATE: HY000, Message: At least PARENTTASKID should be specified in this SQL statement.;

I am able to get the Project,Task and Section table without this error.

How may I solve the subtask table error?
Thanks!

That sounds very specific to your ODBC tool, not sure how much help we can be here. We can try to helpā€¦

Can you share the specific syntax youā€™re using to try and get subtasks? Note that there is no ā€œsubtasks tableā€ in Asana - subtasks are simply regular Asana tasks that have a non-null value in their parent_id field.

1 Like

Thanks Phil,

I am selecting the subtask ā€˜tableā€™ on the dropdown of my ODBC connector

I have also specified the workspace ID and project ID on my ODBC connector

Youā€™re going to need to get support on this issue from the company that built the ā€œCData Asana Sourceā€. Without knowing the internal details of what specific API calls itā€™s making to the Asana API, I donā€™t think thereā€™s any way anyone here will be able to help debug the error.

1 Like