Asana Troubleshooting: No values in some columns
Issue description
Right now, Coupler does not return "name" values on some of Asana's source columns. Example:
We're considering changing this logic, in the meantime, we have developed a workaround to mitigate the impact of this behavior.
Workaround
Depending on which column has missing values, you can usually get the needed details from other Asana objects.
In the example above, we're trying to pull the "Projects" data entity. However, we're missing the owner.name data. We have our owner.gid data, so we can do the following workaround:
1. Create a second source pulling all your "Users" data:
2. During the "Transformations" step, wait for the data preview to load and select the join mode:
3. Selecting the Join mode would "LEFT JOIN" your data, so you can select the following settings so that your project entity's owner.gid gets matched to your user entity's gid data:
4. Press "Create Join"
5. You'll now see the columns of your "Projects" entity joined with the columns from your "Users" entity source. You can apply some transformations to your data, like:
- going to the "Users" data entity preview and hide all columns except the gid and name so that only necessary columns are shown (Hiding Columns):
- You can also rename the column from
nametoowner.name(Renaming Columns):
- Under the main preview, you can hide the empty
owner.namecolumn from the "Projects" entity and also thegidcolumn from the "Users" entity:
- Lastly, you can reorder the column so that it is not placed at the end, but in its original position (Reordering Columns):
