Hi,

Newbie question!

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 s“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 p])

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 “I]”s? 

Thanks,

CB  

resultObject

1:
    general: 
        fullName: Thomas xxx

    jobs:
        1:
            companyName:     AudienceProject
        2:
            companyName:    Legacy
        3:    
            companyName:    Ramboll

2:
    general: 
        fullName: Jules xxx

    jobs:
        1:
            companyName:     Ikoula

3:    
    general:
        fullName: Eric xxx

    jobs:
        1:    
            companyName:     SII

        2:
            companyName:    Gamitec