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

[Saw_Wei_Sheng]

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!

[Phil_Seeman]

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.

[Saw_Wei_Sheng]

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

[Phil_Seeman]

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.