Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Best answer

Extract part of a python response

  • November 22, 2021
  • 2 replies
  • 234 views
T

Hello,

I have a step in my Zap where I need to retrieve a bearer token to use for a later step. This token can be retrieved within a response from a python request.

My response in Zapier looks like this:

 

output_missing

Please define output or return early.

id

8KzjgJ7iu86HBhkCxXu5L8hSoc5sD3Qq

runtime_meta

memory_used_mb

47

duration_ms

857

logs

1

{"expiresAt":"2021-12-22T02:13:20Z","cultureId":1,"companyAccountId":20,"userAccountId":47,"newUrl":null,"refreshToken":"z8+7NQrtekQ35vrR6l03cn+V4mL6CBazO0WACqYjzM0=","token":"{TOKEN}","role":"CorporateInterpreterRootAdmin"}

 

 

I need to extract the {TOKEN} value and be able to re-use it as a field in a later action step.

I tried a few output/return options, but I’m not sure how to do this.

 

Any ideas?

 

Thank you

Thomas

Best answer by robschmidt

Hi @Thomas2M 

You can use python for this (read Zapier python help docs on how to format your code) or you can use formatter>text>extract pattern and use a regex query to extract the token part. This should be more convenient to work with.

 

View original
    Did this topic help you find an answer to your question?
    This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

    2 replies

    robschmidt
    Forum|alt.badge.img+9
    • robschmidtZapier Expert
    • Zapier Expert
    • 617 replies
    • Answer
    • November 22, 2021

    Hi @Thomas2M 

    You can use python for this (read Zapier python help docs on how to format your code) or you can use formatter>text>extract pattern and use a regex query to extract the token part. This should be more convenient to work with.

     

    Outliant.com | Zapier Expert
    T
    • Thomas2MBeginner
    • Author
    • Beginner
    • 7 replies
    • November 22, 2021

    Hi @robschmidt,

    Thank you for pointing me out in the right direction. The formatter with python regex did the trick.

    In case this is helpful for the forum users, here’s the regex I used: (?<="token":").+(?=",)

     

    Terms & Conditions