Unable to get split by to operate

I am grabbing data from an API and the JSON is returning as below:

image

I am attempting to split each field such as ‘email’, ‘site’ etc into its own row using the split by function with this:
image

However, I cannot seem to get them to split. What am I missing from this?

Those fields are already defined when initializing the request and then automatically parsed. You’re already referencing the fields in your conditions. Why the need for split by?

To place in different rows. The emails, website and phone are being returned all in one cell but need to be in individual cells for that business.
The data returned will be multiple businesses, so at presents its set as 3, but user defined could be up to 100.

can you share your editor link?

This topic was automatically closed after 70 days. New replies are no longer allowed.