So I’m working to build a zapier integration for our service. The data payload we send has a few different sets of arrays which I understand zapier refers to as “Line Items”
I cannot figure out to work with these for the life of me. For example, we return a “contact like object” that, for the sake of this conversation, looks like
n
{
first_name: “jane”,
last_name: “doe,
email: “jane@email.com”,
},
{
first_name: “john”,
last_name: “doe,
email: “john@email.com”,
},
]
When I test the Zap, it sees the object and displays them as line items. But when I got to access the data, the first name key returns a comma-separated list of each object's first name. I.e. “jane, john”. This is useless.
So I searched, found, and played with the Formatter tool and Looping by Zapier, but no matter what I do or how I configure these according to the docs, I still end up with the exact string.
For example, I tried to dumb it down and make a google spreadsheet adding a row just like it outlines in this article: https://zapier.com/blog/formatter-line-item-automation/. I followed this exactly, and it didn’t work. The result was a single row added where first_name was “jane,john”
What am I missing? Why is this so difficult?