About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Get Asana Task by ID – custom fields returned accessible easily / are not flat

  • 13 September 2022
  • 9 replies
  • 216 views
F

Hi,

Not sure if anyone has encountered this.

 

Task Affected

  • Find Task in Project in Asana
  • Find Task by ID
  • GET Asana Task by ID

What I’m trying to do:

  • Get the values of specific custom fields. 

Problem

  • Custom Fields are returned in an Array (not a problem)
  • However, Zapier is grouping custom fields within the Array by the same key, e.g. an array of GUIDs. [See screenshot 1 and 2] 

Expected Result

  • Expect it to group custom fields by GUID instead. 
  • E.g. being able to use the custom field value for each specific GUID.
  • I believe the way I can get around this at the moment is to format / map each to their respective field, but that seems counter-intuitive 

Options?

  • Is there anyway to play around with the array itself; and format this myself?
  • I know with Asana Zapier Triggers, the custom fields are their own item to select in Zapier. So I do not know why this is differentiated with tasks. 

Any help would be greatly appreciated!

2 Attachments

9 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @fwp 

Good question.

This is the expected behavior for how Zapier handles line items with the same parameter labels.

OPTIONS

Formatter > Utilities > “Line Items”

Code

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
F

Hey thanks for the quick response. So following this and trying Utilities > Line Items; the commas for empty fields seem to be filtered out. 

 

Is there a way around this? 

 

The issue is – some fields may be empty – so the order is not consistent, and then cannot actually map the fields to the correct places. 

Troy Tessalone
Userlevel 7
Badge +14

@fwp 

Would need to see detailed screenshots with how your Formatter step is configured.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
F

Hey Troy

Thanks for the quick response.

I’ve attached some screenshots – of trying Formatter < Line Items; and then also with Code.

 

4 Attachments
Troy Tessalone
Userlevel 7
Badge +14

@fwp 

The attachments look like the didn’t upload correctly.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@fwp 

Perhaps check out some of these “Code Mode” articles for help.

https://community.zapier.com/search?q=code%20mode&content_type%5B0%5D=article

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
F

I’ve re uploaded

4 Attachments
Troy Tessalone
Userlevel 7
Badge +14

@fwp 

Code step output depends on the configured code being used, which isn’t shown in a screenshot.

NOTE: If any of the values have commas that can mess up the parsing.

 

If you use Formatter > Utilities > Line Items to Text

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
christina.d
Userlevel 7
Badge +9

Hey there, @fwp! I wanted to stop in and see if you were able to get this sorted?

Full transparency, supporting custom code is outside the scope of Zapier Support but it’s possible a brainiac member of the Community is down to help! 🙃

Otherwise here’s another resource that could help:

Keep us posted how you’re getting along here. 🤗

Reply


Terms & Conditions