I am trying to transfer LinkedIn data into spreadsheet but every time I am getting the same error in JSON parse, how do I solve it?
Looking forward for your support on this.
@Daniyal_Jhosawa
Hi, could you please provide json input data?
Let a Json validator check your json input. I use: https://jsonlint.com/
This will point out the error and you can take action to fix it.
1 Like
[{“profileUrl”:“Sales Navigator Rugarcia Torres”,“firstName”:“Arturo”,“lastName”:“Rugarcia Torres”,“companyName”:“SAP Soluciones “,“title”:“Director Ejecutivo de Recursos Humanos”,“companyId”:””,“companyUrl”:“”,“regularCompanyUrl”:“”,“summary”:“Experiencia de más de 35 años en el campo de Recursos Humanos, desempeñando puestos de Dirección en las distintas áreas; implementando Programas Estratégicos y de Transformación en la Gestión de RRHH; con una cobertura de administración de más de 1,000 empleados, en diferentes plazas del territorio nacional. nnActualmente Director Ejecutivo de Recursos Humanos en SAP Soluciones, cuya misión es brindar servicios a las empresas, que contribuyan a fortalecer una optima gestión del Capital Humano; ofreciendo beneficios a los empleados, que fortalezcan su sentido de pertenencia. nnLicenciado en Psicología por la Universidad Iberoamericana en México, con especialización en Psicología Industrial.n”,“titleDescription”:“En SAP Soluciones nuestra misión es Brindar servicios a las empresas, que contribuyan a fortalecer una optima gestión del Capital Humano; ofreciendo beneficios a los empleados, que fortalezcan su sentido de pertenencia. “,“industry”:””,“companyLocation”:“”,“location”:“Guadalajara, Jalisco, Mexico”,“durationInRole”:“7 years 7 months in role”,“durationInCompany”:“7 years 7 months in company”,“pastExperienceCompanyName”:“”,“pastExperienceCompanyUrl”:“”,“pastExperienceCompanyTitle”:“”,“pastExperienceDate”:“”,“pastExperienceDuration”:“”,“connectionDegree”:“3rd”,“profileImageUrl”:“https://media.licdn.com/dms/image/v2/C5603AQHffMF2jLAefw/profile-displayphoto-shrink_800_800/profile-displayphoto-shrink_800_800/0/1516976044975?e=1742428800&v=beta&t=LkWt8qlBUDIDX-bzEdj3NuUjbD7ssm5Xn7CPzJNRMaQ",“sharedConnectionsCount”:0,“name”:"Arturo Rugarcia Torres”,“vmid”:“ACwAABmb_PkBS05uOOEzlQWzt4rsIKhbbFR3pv4”,“linkedInProfileUrl”:“https://www.linkedin.com/in/ACwAABmb_PkBS05uOOEzlQWzt4rsIKhbbFR3pv4/",“isPremium”:false,“isOpenLink”:false,“query”:"https://www.linkedin.com/sales/search/people?query=(filters%3AList((type%3ASAVED_LEADS_AND_ACCOUNTS%2Cvalues%3AList((id%3ASA%2CselectionType%3AINCLUDED)))%2C(type%3APERSONA%2Cvalues%3AList((id%3A1878768564%2CselectionType%3AINCLUDED)))))&sessionId=xc%2FK%2BfmOS7iU96wH9CDLzA%3D%3D”,“timestamp”:“2025-01-18T10:12:14.787Z”,“defaultProfileUrl”:“https://linkedin.com/in/arturo-rugarcia-torres-b09a81bb"},{“profileUrl”:“https://www.linkedin.com/sales/lead/ACwAAAAMoBsBiuU8IWuE2fdSetfOnxgTsdRBF00,NAME_SEARCH,VRQj”,“fullName”:"David Keene”,“firstName”:“David”,“lastName”:“Keene”,“companyName”:“Wipro”,“title”:“Chief Marketing Officer, Europe”,“companyId”:“1318”,“companyUrl”:“Sales Navigator Marketing Officer with a track record of driving revenue growth and brand impact. I bring deep and wide experience from senior leadership roles in marketing, growth strategy, and product development with scale-ups and global tech leaders, including Google, Salesforce, SAP, and Oracle. My superpower is scaling growth businesses by building high-performing teams that grow new lines of business for the B2B world.”,“titleDescription”:“Global B2B software and services system integrator. $11B global revenue. I lead marketing for the $4B European P&L. I shape brand strategy and facilitate marketing planning, sales enablement, and demand creation. Reporting to the regional CEO and as part of the global CMO council, I own the regional marketing strategy aligned with service-specific growth and margin objectives. nnDespite challenging industry conditions, we maintained or grew bookings and margins across our six European regions. Growth has been driven primarily through account-based marketing (ABM), enhancing the marketing technology stack, high-impact leadership events, a digital content studio, and partnership marketing with technology alliances, hyperscalers and industry advisors.”,“industry”:“IT Services and IT Consulting”,“companyLocation”:“Bengaluru, Karnataka, India”,“location”:“London Area, United Kingdom”,“durationInRole”:“2 years 1 month in role”,“durationInCompany”:“2 years 1 month in company”,“pastExperienceCompanyName”:“”,“pastExperienceCompanyUrl”:“”,“pastExperienceCompanyTitle”:“”,“pastExperienceDate”:“”,“pastExperienceDuration”:“”,“connectionDegree”:“3rd”,“profileImageUrl”:“https://media.licdn.com/dms/image/v2/D4E03AQHuALIyqbbZ6Q/profile-displayphoto-shrink_800_800/profile-displayphoto-shrink_800_800/0/1705680715026?e=1742428800&v=beta&t=b-vagvERkmgPliyGAf4N7_VHIyxdNR0bkSPr79-SZQw",“sharedConnectionsCount”:0,“name”:"David Keene”,“vmid”:“ACwAAAAMoBsBiuU8IWuE2fdSetfOnxgTsdRBF00”,“linkedInProfileUrl”:“https://www.linkedin.com/in/ACwAAAAMoBsBiuU8IWuE2fdSetfOnxgTsdRBF00/",“isPremium”:true,“isOpenLink”:false,“query”:"https://www.linkedin.com/sales/search/people?query=(filters%3AList((type%3ASAVED_LEADS_AND_ACCOUNTS%2Cvalues%3AList((id%3ASA%2CselectionType%3AINCLUDED)))%2C(type%3APERSONA%2Cvalues%3AList((id%3A1878768564%2CselectionType%3AINCLUDED)))))&sessionId=xc%2FK%2BfmOS7iU96wH9CDLzA%3D%3D”,“timestamp”:“2025-01-18T10:12:14.787Z”,“defaultProfileUrl”:“https://linkedin.com/in/davidkeenex"},{“profileUrl”:“https://www.linkedin.com/sales/lead/ACwAAADotCwBXc9qiBLV8PnDxwZHx5CNrV1mlc0,NAME_SEARCH,yDj2”,“fullName”:"Sanjay Kawle”,“firstName”:“Sanjay”,“lastName”:“Kawle”,“companyName”:“Urban Ladder”,“title”:“Chief Operating Officer”,“companyId”:“2482371”,“companyUrl”:“Sales Navigator professional with 25+ years of rich & extensive experience in Thought Leadership, Strategic Operations, Supply Chain Management, P & L Management, and People Management across IT/ ITES, E-commerce, Manufacturing, Consumer Services, FMCG, and B2B business.nnKey Accomplishments:nntWinner of ‘Business Transformation Leader 2021’ award by MINT | Techcircle (a Hindustan Times media Company) in June’2021ntBest People Manager award by Chairman, Wipro LimitedntChampion – Profitable Growth Journey award in 2020 & 21 ntSolitaire Award winner for 3 consecutive years from FY 2009 - 12ntBest LOB Delivery Head award for FY 2012-13ntBest Productivity Program award for FY 2012-13ntChampioned certifications of ISO 9001/ 14001 / 20001 / 27001 for Manufacturing and Services BiznnKey Skills:nStrategic Planning, Thought Leadership, Business Growth & Management, Manufacturing Operations, and P&L monitoring, Operational Excellence, Revenue Expansion, Supply Chain Management, Strategic Alliances & Partnership, Scaling up the start-ups, Turnaround managementnnSummary:n 1. Growth Catalyst with impressive success in contributing to the success of company progression and n amplifying business margin through short-term & long-term planning. n 2. Expertise in building sophisticated business models and vast knowledge of both the marketplace and n the capabilities & complexities of products; with a consistent record of delivering results in growth, n revenue, operational performance, and profitabilityn 3. Strong business acumen with proficiency in establishing strategic alliances with key decision-makers/ n leaders across target organizations and penetrating new markets for revenue expansion & business n growthn 4. People Leader, who has successfully led and motivated teams in cross-cultural environments towards n growth and success in the organization; created a clear & compelling view of the future through n coaching and executionn 5. Keen strategist & implementer with skills in leading personnel towards the accomplishment of common n goalsnnnA COO, Service Delivery, Supply Chain, and Manufacturing Operations professional you can rely on!!”,“titleDescription”:“COO at Urban Ladder (A Reliance Retail Company) managing Operations, Supply Chain, P&L, Quality, Customer Success, and Human Resources. Heading new business verticals Institutional Business and Services business.”,“industry”:“Technology, Information and Internet”,“companyLocation”:“Bengaluru, Karnataka, India”,“location”:“Bengaluru, Karnataka, India”,“durationInRole”:“3 years in role”,“durationInCompany”:“3 years in company”,“pastExperienceCompanyName”:“”,“pastExperienceCompanyUrl”:“”,“pastExperienceCompanyTitle”:“”,“pastExperienceDate”:“”,“pastExperienceDuration”:“”,“connectionDegree”:“2nd”,“profileImageUrl”:“https://media.licdn.com/dms/image/v2/C5603AQFc9i5p9Vj7kw/profile-displayphoto-shrink_800_800/profile-displayphoto-shrink_800_800/0/1626344695407?e=1742428800&v=beta&t=QVVpmiEVe_mb599d0WyBeZMZR1mT8blgonAj1BYzQBc",“sharedConnectionsCount”:7,“name”:"Sanjay Kawle”,“vmid”:“ACwAAADotCwBXc9qiBLV8PnDxwZHx5CNrV1mlc0”,“linkedInProfileUrl”:“https://www.linkedin.com/in/ACwAAADotCwBXc9qiBLV8PnDxwZHx5CNrV1mlc0/",“isPremium”:false,“isOpenLink”:false,“query”:"https://www.linkedin.com/sales/search/people?query=(filters%3AList((type%3ASAVED_LEADS_AND_ACCOUNTS%2Cvalues%3AList((id%3ASA%2CselectionType%3AINCLUDED)))%2C(type%3APERSONA%2Cvalues%3AList((id%3A1878768564%2CselectionType%3AINCLUDED)))))&sessionId=xc%2FK%2BfmOS7iU96wH9CDLzA%3D%3D”,“timestamp”:“2025-01-18T10:12:14.787Z”,“defaultProfileUrl”:“https://linkedin.com/in/sanjay-kawle-6101355"},{“profileUrl”:“https://www.linkedin.com/sales/lead/ACwAAAAm9rQBJTmwNiMMIa1-6q7wxqYtBREni_M,NAME_SEARCH,2viQ”,“fullName”:"Ed Corno”,“firstName”:“Ed”,“lastName”:“Corno”,“companyName”:“IBM”,“title”:“Chief Technology Leader”,“companyId”:“1009”,“companyUrl”:“Sales Navigator your organization need an Information Technology executive that has just the right mix of experience in business, technology and sales? One that uses skills to drive business results by implementing technology to increase sales and reduce costs. nnAs an accomplished Information Technology executive, I have unique capabilities that are a combination of business and technology expertise. This experience focuses on technical strategy, enterprise wide architecture and program management. nnFor added benefit, I thoroughly understand “financials" specifically Profit and Loss (P&L) responsibility, business development and sales. This involves selling to clients in a consultative manner. I’ve increased revenue while becoming a trusted advisor for clients by asking the right questions and providing the right solutions. Also, I’ve presented to C-level executives from CIOs to CEOs as well as Board of Directors about the benefits of improved systems.nnIn addition, I’m passionate about innovation that provides positive change and growth for an organization. I’m an expert in Cloud, 3D Printing, and Internet of Things (IoT). My latest efforts involve “Design Thinking" for enterprises that can change how companies develop products.nnOver the last twenty years, I’ve helped Fortune 500 corporations and small companies determine the best way to use technology evolving from the “as is" state to the “to be” state. Also, I advise startups and emerging companies on how to grow their business. This includes making sure solutions work by providing extensive Enterprise Architecture expertise.nnLeadership: Common Services approach with the Office of CIO at EDS to reduce expenses by 33%.nnStrategy: Outsourcing Data Center facilities at a cost of $81 million dollar over five years.nnSolutions: Problem solving by developing pilots using sensors to track packages, estimated savings of $12 million a year.nnCustomer Relationships: Instituted improvements and key metrics moving from yellow to green.nnResults: Won a web portal modernization program valued at $78 million over 3 years.”,“titleDescription”:“Responsible for designing the strategy and architecture to drive digitalization and innovation.nDemonstrated deep industry knowledge, broad technology skills and business abilities for Consumer Packaged Goods companies that included the following: Kraft-Heinz, Mondelez, Campbell Soup, Colgate and Post Holdings. n•tIndustry thought leader that combines technical and business insights, while working across teams and business units in different countries and regions. Established the Account Chief Technical Officer role, that involved long-term relationships with technical and business decision makers at the C-level. Partnered with line-of-business leaders and senior executive throughout the account.n•tApplied industry expertise and thought leadership to identify client insights to enable specific solutions. Developed a strategy for IBM products, portfolio and solutions to increases sales by leveraging the IBM value proposition. As a Trusted Advisor, expanded digital transformation that resulted in an increase of over 22% in adoption of IBM technology.n•tExpanded and deepened revenue by turning global customers into strategic partnerships. This occurred through trusted, long-term relationships by exceeding business, technical and customer needs. n•tIncreased sales by developing and driving opportunities founded on technical and business best practices. Presented opportunities to the customer while creating demand. Developed an over-arching plan, within a larger strategy, to identify and qualify a set number of opportunities for product sales, solutions sales, and sales plays. This approach increased sales by over 130% at Colgate.n•tEstablished best practices by focusing on account planning that aligned with quota attainment, goals, and customer consumption. Increased customer technology engagement by driving technical resources to enable client digital transformation. Exceeded quote by $36 million in one year by focusing on solving Cloud and API integration.”,“industry”:“IT Services and IT Consulting”,“companyLocation”:“Armonk, New York, United States”,“location”:“Greater St. Louis”,“durationInRole”:“9 years 1 month in role”,“durationInCompany”:“9 years 1 month in company”,“pastExperienceCompanyName”:””,“pastExperienceCompanyUrl”:”“,“pastExperienceCompanyTitle”:”“,“pastExperienceDate”:”“,“pastExperienceDuration”:”“,“connectionDegree”:“3rd”,“profileImageUrl”:“https://media.licdn.com/dms/image/v2/C4D03AQGHN9qbt4Q8XA/profile-displayphoto-shrink_800_800/profile-displayphoto-shrink_800_800/0/1516266947979?e=1742428800&v=beta&t=jIb7m0Q7xy51pPtZSrj7IZJO0w8HD9ai6y_pjFSkTGw",“sharedConnectionsCount”:0,“name”:"Ed Corno”,“vmid”:“ACwAAAAm9rQBJTmwNiMMIa1-6q7wxqYtBREni_M”,“linkedInProfileUrl”:“https://www.linkedin.com/in/ACwAAAAm9rQBJTmwNiMMIa1-6q7wxqYtBREni_M/",“isPremium”:true,“isOpenLink”:true,“query”:"https://www.linkedin.com/sales/search/people?query=(filters%3AList((type%3ASAVED_LEADS_AND_ACCOUNTS%2Cvalues%3AList((id%3ASA%2CselectionType%3AINCLUDED)))%2C(type%3APERSONA%2Cvalues%3AList((id%3A1878768564%2CselectionType%3AINCLUDED)))))&sessionId=xc%2FK%2BfmOS7iU96wH9CDLzA%3D%3D”,“timestamp”:“2025-01-18T10:12:14.787Z”,“defaultProfileUrl”:“https://linkedin.com/in/ed-corno-898a31"},{“profileUrl”:“https://www.linkedin.com/sales/lead/ACwAAAcJswcBcWsFmWKQqSrzk-zHtPtCrQY2uro,NAME_SEARCH,vfq5”,“fullName”:"Ravi Teja Palla”,“firstName”:“Ravi Teja”,“lastName”:“Palla”,“companyName”:“Urban Ladder”,“title”:“Chief Business Officer”,“companyId”:“2482371”,“companyUrl”:“Sales Navigator, Think, Inspire, Achieve.nnExperienced business leader with a strong background in e-commerce, omnichannel strategy, and retail operations, currently overseeing a business with a top-line of 300 crore. Skilled in building and scaling operations, optimizing digital storefronts, and integrating online and offline channels to enhance customer experiences. A balanced approach to category management, product development, and brand positioning, with a focus on improving profitability and operational efficiency. Committed to leveraging data-driven strategies and cross-functional leadership to support sustainable business growth.”,“titleDescription”:“Recognized for Exceptional Leadership: Promoted to Chief Business Officer for the core B2C business based on outstanding performance as Head of Interior Business.nnMarketing Overhaul: Led a comprehensive marketing revamp, implementing an OMO (online merge offline) strategy. Enhanced UI/UX for online storefronts and revamped ATL & BTL marketing, improving engagement and sales.nnRevenue Stabilization: Despite leadership exits, maintained year-over-year revenue growth through data-driven strategies.nnCategory Overhaul: Refocused the category team towards higher gross margin goals, boosting profitability.nnProduct Premiumization: Expanded product lines from mid-premium to sub-luxury, driving increased AOV and margins.nnStrategic Market Exits: Led a data-driven analysis, exiting Smart Bazaars to enhance brand coherence.nnBrand Redefinition: Conducted research and workshops to reposition Urban Ladder as a premium, design-led brand. Launched a new brand identity with a film and go-to-market strategy.nnRetail Management: Oversaw 40+ stores across India, turning 10 of 20 unprofitable locations profitable through operational efficiency and strategic focus.nnStore Upgrades: Directed store refresh initiatives, aligning the look with the brand’s premium identity.nnMarketplace Refocus: Shifted marketplace operations towards profitability through a customer-centric and streamlined approach.nnKey CompetenciesnnStrategic Business LeadershipnOmnichannel Retail Integration (OMO)nCategory & Product ManagementnDigital Marketing & UI/UXnBrand Identity & Go-to-Market StrategynData-Driven ProfitabilitynRetail Expansion & ProfitabilitynPremium Product & Brand PositioningnnTeams ManagednnMarketingnOnline & Retail RevenuenCategory (Home Brands, Marketplace)nProduct DesignnCreative & BrandnVisual Merchandising (Store & Digital)”,“industry”:“Technology, Information and Internet”,“companyLocation”:“Bengaluru, Karnataka, India”,“location”:“Bengaluru, Karnataka, India”,“durationInRole”:“1 year 1 month in role”,“durationInCompany”:“9 years 9 months in company”,“pastExperienceCompanyName”:”“,“pastExperienceCompanyUrl”:”“,“pastExperienceCompanyTitle”:”“,“pastExperienceDate”:”“,“pastExperienceDuration”:”",“connectionDegree”:“2nd”,“profileImageUrl”:“https://media.licdn.com/dms/image/v2/D4D03AQGJPfoXtPgHGg/profile-displayphoto-shrink_800_800/profile-displayphoto-shrink_800_800/0/1729657468715?e=1742428800&v=beta&t=hCAX9EHP1bo4KCgkB4AeCKKhnswkr5cq_fu1RobcDaM",“sharedConnectionsCount”:5,“name”:"Ravi Teja Palla”,“vmid”:“ACwAAAcJswcBcWsFmWKQqSrzk-zHtPtCrQY2uro”,“linkedInProfileUrl”:“https://www.linkedin.com/in/ACwAAAcJswcBcWsFmWKQqSrzk-zHtPtCrQY2uro/",“isPremium”:false,“isOpenLink”:false,“query”:"https://www.linkedin.com/sales/search/people?query=(filters%3AList((type%3ASAVED_LEADS_AND_ACCOUNTS%2Cvalues%3AList((id%3ASA%2CselectionType%3AINCLUDED)))%2C(type%3APERSONA%2Cvalues%3AList((id%3A1878768564%2CselectionType%3AINCLUDED)))))&sessionId=xc%2FK%2BfmOS7iU96wH9CDLzA%3D%3D”,“timestamp”:“2025-01-18T10:12:14.787Z”,“defaultProfileUrl”:"https://linkedin.com/in/ravi-teja-palla-14766333"}]"}]
I am trying to fetch LinkedIn sales navigator URL from Phantom Buster
this is a text parse replace output and json parse input but I am getting an error in json parse
DataError
Source is not valid JSON.
- Expected ‘,’ or ‘}’ after property value in JSON at position 10318
At least “ and ” needs to be corrected to ". Anyway, Key and Value in JSON must be enclosed in double quotes.
I tried to make a valid json file out of it.
What needed to be done for sure is to replace the quotes. After that there are some quotes in the strings themselves these had to be escaped by \”. Finally, at the very end the array has been double closed. this also had to be removed.