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?