We have some data coming into our Zap from PhantomBuster - we need to select specific parts of the data and add to a google sheet - example input data below.
The incoming data is in batches of 10, and we’re using Add Spreadsheet Rows to process all 10.
However, when I select resultObject: jobs: companyName, the example data is presented as [“AudienceProject”, “Legacy”, “Ramboll”], [“Ikoula”], [“SII”, “Gamitec”] -- i.e. each result is delimited by “,” but the individual results have a 1:many relationship with the jobs (delimited in )
I want to be able to select the first company name for each record (i.e. AudienceProject, Ikoula, SII), but how can I parse the “”s?
fullName: Thomas xxx
fullName: Jules xxx
fullName: Eric xxx
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.