How to get phatombuster outputs as a Line Item and feedback to hubspot

Hi @jbro - Can you show me an example JSON or CSV output? Thanks!

[{"general":{"imgUrl":"https://media-exp1.licdn.com/dms/image/C5603AQFmyU9f4skoHw/profile-displayphoto-shrink_800_800/0/1608558613488?e=1614211200&v=beta&t=K3zpgSPrzh-oefBG9xDeK3oFg-O9zrkZ74JiUNKJ0yg","fullName":"Siddharth Dalwadi","headline":"Business Development Lead: West India at Amazon Web Services (AWS)","company":"Amazon Web Services (AWS)","school":"UCD Michael Smurfit Graduate Business School","location":"Bangalore Urban, Karnataka, India","connections":"500+ connections","profileUrl":"https://www.linkedin.com/in/siddharth-dalwadi-a075a2a7/","connectionsCount":500,"connectionDegree":"3rd+","description":"World Wide Public Sector | INDIA | Education","firstName":"Testfirstname","lastName":"testlastname","vmid":"ACoAABawqScBXmwQK_LmVA8YN4GqDhGT2ThodLw","linkedinSalesNavigatorUrl":"https://www.linkedin.com/sales/people/ACoAABawqScBXmwQK_LmVA8YN4GqDhGT2ThodLw,name","mutualConnectionsUrl":"https://www.linkedin.com/search/results/people/?facetNetwork=%5B%22F%22%5D&facetConnectionOf=%5B%22ACoAABawqScBXmwQK_LmVA8YN4GqDhGT2ThodLw%22%5D&origin=MEMBER_PROFILE_CANNED_SEARCH&RESULT_TYPE=PEOPLE","connectionsUrl":"https://www.linkedin.com/search/results/people/?facetConnectionOf=%5B%22ACoAABawqScBXmwQK_LmVA8YN4GqDhGT2ThodLw%22%5D&facetNetwork=%5B%22F%22%2C%22S%22%5D&origin=MEMBER_PROFILE_CANNED_SEARCH","subscribers":559,"backgroundUrl":"https://media-exp1.licdn.com/dms/image/C4D16AQFwfuYO8HjmEg/profile-displaybackgroundimage-shrink_350_1400/0/1555508062351?e=1614211200&v=beta&t=iaaKMCDGFR9rn3GDay2y522CI6mIm3Mp9qdIbyaKBC8"},"jobs":[{"companyName":"Amazon Web Services (AWS)","companyUrl":"https://www.linkedin.com/company/amazon-web-services/","jobTitle":"Business Development Lead: West India","dateRange":"Apr 2020 – Present","location":"Bengaluru, Karnataka, India","description":null},{"companyName":"Amazon Web Services (AWS)","companyUrl":"https://www.linkedin.com/company/amazon-web-services/","jobTitle":"Business Development Lead","dateRange":"Oct 2019 – Mar 2020","location":"Bengaluru, Karnataka, India","description":null},{"companyName":"Amazon Web Services (AWS)","companyUrl":"https://www.linkedin.com/company/amazon-web-services/","jobTitle":"Lead Development Representative","dateRange":"Mar 2018 – Sep 2019","location":"County Dublin, Ireland","description":null},{"companyName":"Lycamobile Group","companyUrl":"https://www.linkedin.com/company/lycamobile/","jobTitle":"Area Sales Executive","dateRange":"Nov 2016 – Mar 2018","location":"Dublin","description":"- Working closely with retailers and other merchandisers to increase Brand awareness of Lycamobile and its products\n- Drive Sales and revenue in accordance with Management targets\n- Preparing intuitive Branding reports every month\n- Managing Stock levels and distribution of Lycamobile products \n- Managing 300 plus retailers and merchandisers in the allocated zone."},{"companyName":"Cognizant","companyUrl":"https://www.linkedin.com/company/cognizant/","jobTitle":"Business Development Executive","dateRange":"Sep 2013 – Jul 2016","location":"Bengaluru Area, India","description":"Project Description: \n\nQA Hub ‚is product portfolio that leverages Cognizant’s best of breed technology to address key challenges in the QA lifecycle. \nQA Hub has a portfolio of products ranging from test lifecycle products to Industry specific tools.\n\nRoles & Responsibilities:\n\n•\tResponsible for gathering business requirements, communicate with development, QA\n•\tHandling the ‘Business expansion’ and ‘Strategy formulation’ for Cognizant QA hub Products\n•\tResearching on implementing new enhancements\n•\tConducting client demos for various QA Hub products (face to face, video con, tele con).\n•\tMarket Research\n•\tCreating Return on Investment (ROI) documents for all the software tools\n•\tGenerating healthy pipeline for internal sales\n•\tResponsible for running various marketing campaigns to generate interest and awareness about QA Hub™ across locations\n•\tConducted Roadshows for different products across Locations\n•\tPrepare intuitive reports and graphs, which depict the health of QA Hub™ products.\n•\tIdentifying prospective customers (Pro Active Sales)\n•\tServing as a liaison between the Customer and offshore development team\n\n\nhttps://www.cognizant.com/quality-engineering-and-assurance"}],"schools":[{"schoolUrl":"https://www.linkedin.com/school/374058/?legacySchoolId=374058","schoolName":"UCD Michael Smurfit Graduate Business School","degree":"Master's degree","degreeSpec":"Management","dateRange":"2016 – 2017","description":""},{},{"schoolUrl":"https://www.linkedin.com/school/160011/?legacySchoolId=160011","schoolName":"PES University","degree":"Bachelor of Engineering (B.E.)","degreeSpec":"Electronics and Communications Engineering","dateRange":"2009 – 2013"}],"details":{"linkedinProfile":"https://www.linkedin.com/in/siddharth-dalwadi-a075a2a7","companyWebsite":"http://aws.amazon.com","mailFromDropcontact":"ds@amazon.com"},"skills":[{"name":"Microsoft Office","endorsements":"5"},{"name":"Customer Service","endorsements":"3"},{"name":"Microsoft Excel","endorsements":"3"},{"name":"HTML","endorsements":"3"},{"name":"Microsoft Word","endorsements":"2"},{"name":"C++","endorsements":"2"},{"name":"PowerPoint","endorsements":"1"},{"name":"SQL","endorsements":"1"},{"name":"C","endorsements":"1"},{"name":"Leadership","endorsements":"2"}],"allSkills":"Microsoft Office, Customer Service, Microsoft Excel, HTML, Microsoft Word, C++, PowerPoint, SQL, C, Leadership","dropcontact":{"email":"test@amazon.com","qualification":"test@pro","civility":"Mr","company":"Amazon Web Services (Aws)","first_name":"testfirstname","full_name":"firstname lastname","last_name":"Dalwadi","linkedin":"www.linkedin.com/in/siddharth-dalwadi-a075a2a7","naf5_code":"47.91A","naf5_des":"Vente à distance sur catalogue général","nb_employees":"250-499","siren":"487773327","siret":"48777332700027","siret_address":"67 fake street","siret_city":"testcity","siret_zip":"12345","vat":"FR123456789","website":"www.aws.amazon.com"},"query":"https://www.linkedin.com/in/siddharth-dalwadi-a075a2a7/","timestamp":"2020-12-24T00:45:55.895Z"}]

@ikbelkirasan Hi The json results are in the message and csv file is attached

Hey @jbro if you’re just trying to get Name 3 could you use Zapier’s split text feature to return the value? https://zapier.com/blog/zapier-formatter-guide/#split - If you split the text into separate values, you’ll be able to grab the third value as you’ve stated. 

Let me know if that works… Or feel free to book some time with me at www.andywingrave.com using the calendar on the bottom right. I’m sure I can solve your problem on a call.