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