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.

Hi!

I get something like this webhook request:

<LoanPrograms>
    <LoanProgram>
        <Offers>
            <Offer>
                <InterestRate>5.25</InterestRate>
                <APR>5.362</APR>
            </Offer>
            <Offer>
                <InterestRate>5.499</InterestRate>
                <APR>5.521</APR>
            </Offer>
            <Offer>
                <InterestRate>5.7</InterestRate>
                <APR>5.521</APR>
            </Offer>
        </Offers>
    </LoanProgram>
    <LoanProgram>
        <Offers>
            <Offer>
                <InterestRate>3.75</InterestRate>
                <APR>5.362</APR>
            </Offer>
            <Offer>
                <InterestRate>3.75</InterestRate>
                <APR>5.521</APR>
            </Offer>
        </Offers>
    </LoanProgram>
</LoanPrograms>


Each LoanProgram object can contain a different number of Offer objects.
My task is to get the Offer fields so that it is clear which LoanProgram they belong to.

When I map the fields in the Zapier interface, it looks exactly like I want it to - in the form of a two-dimensional array.
 


BUT when I send this data to my endpoint, I lose all the square brackets and get the data just separated by commas.
 


Is there any way to get this data exactly as it is displayed in the UI?
I tried to create a code step and so on, but I still got corrupted data at the entrance to it.

Thank you!

Hi @Roman Nosachev 

Good question.

You’ll likely need to use a Code step to handle the variable number of nested arrays.

https://zapier.com/apps/code/help

 

Consider hiring a Zapier Expert if you need help: https://zapier.com/experts

Hi @Troy Tessalone

Thank you for your answer.

Unfortunately it doesn’t work. In this variable, I already get values without square brackets, that is, everything is mixed up.

 

Code

 

Result

 

Is there any way to get the raw XML part? It looks like our integration has a serious problem.

@Roman Nosachev

The Code step would need to be configured to parse the raw data, which requires knowledge of Python or JavaScript to loop and traverse nested array data.

 

 

Thanks @Troy Tessalone 

I implemented this in code step and it wasn’t too difficult.

Terms & Conditions