I'm new to Skyvia but the company I work for is interested in using your service to automate reports.
I'm currently trying to import Asana tasks into a BigQuery table for analysis. I do not appear to be able to correctly map the custom fields to the necessary field in BigQuery.
I believe that the issue is the way in which the data is nested in Asana's API response.
Here is an example of a custom field response:
{ "gid": "782786653325514",
"enabled": true,
"name": "Deal Value",
"numbervalue": 3000,
"precision": 2,
"createdby": {
"gid": "34519764825689",
"name": "Reinart Bacalso",
"resourcetype": "user"
},
"displayvalue": "3000.00",
"resourcesubtype": "number",
"resourcetype": "customfield",
"type": "number"
}
Since the customfields value is an array of similar objects, I would need to perform a source lookup to retrieve the correct entry in the array and then pick off the display_value entry.
The only options that I can see on Skyvia are the following: Description, EnumOptions,Id,Name,Precision,Type,WorkspaceId.
Could you let me know if I am missing something and if it is possible to achieve what I am trying to do?
Thanks
