Parse json items

HI, maybe someone can point me into the right directions. I´m trying to split out the phone numbers, email addresses and adress field.

I tried to use json Parse aswell set node, but not getting anywhere near.

{
  "responseHeader": {
    "zkConnected": true,
    "status": 0,
    "QTime": 4,
    "params": {
      "q": "companyId:DE*",
      "fl": "minhash,companyId,lang,title,content,url,sax-apply_now_link,sax-email_addresses,sax-addresses,sax-phone_numbers",
      "start": "0",
      "q.op": "OR",
      "rows": "5"
    }
  },
  "response": {
    "numFound": 1932186,
    "start": 0,
    "numFoundExact": true,
    "docs": [
      {
        "sax-apply_now_link": [
          "https://jobs.theguardian.com/apply/8644209/deputy-director-shared-service-design-and-cloud-transformation?LinkSource=TopJob"
        ],
        "title": [
          "Deputy Director, Shared Service Design and Cloud Transformation job with GOVERNMENT RECRUITMENT SERVICES | 8644209"
        ],
        "content": [
          "Deputy Director, Shared Service Design and Cloud Transformation Ref: 312414 Salary: £75,000 - £117,800 Non civil servants will be expected to start at the salary minimum if successful. Standard pay rules apply for existing civil servants. Location: Bristol, Glasgow, Manchester, Newcastle-upon-Tyne, York Closing date: 11:55 pm on Sunday 15 October 2023. Job summary Shared Services for Government (SSfG) is a Directorate within the Government People Group in the Cabinet Office. We are at the heart of the Cabinet Office and play a key role in driving modernisation and reform across the whole of the Civil Service. What we do, how we work and all that we achieve, contributes to making this a great Civil Service. The Shared Services Strategy for Government is an enabler of the Civil Service modernisation and reform agenda, playing a part in driving automation and interoperability across government. We are the centre of expertise working across departments to make it easier for civil servants to use platforms for HR, finance and payroll. We launched the new Shared Services Strategy for Government in 2021, of which our overarching objectives are: Meeting end-user needs, promoting excellence and convenience for both staff and managers Delivering value and efficiency, consolidating technology in cluster service centres, including all transactional services Convergence around processes and data, including the consolidation and modernisation of technology platforms, while maintaining choice for departments. This is an exciting opportunity to join the SSfG Directorate in a leadership role at what is a pivotal time in the implementation of the strategy. You will be working with a highly motivated and passionate group of people, helping to shape and drive forward the Shared Services Strategy for Government. Our leaders are transformational, innovative and exceptional at creating the right environment for our colleagues to grow and deliver. As Deputy Director for Shared Service Design and Cloud Transformation, you will be a valued member of the SSfG senior leadership team and play a crucial role in providing senior leadership to cluster programmes, including challenging System integrators with appropriate domain knowledge. This is a significant role requiring the successful postholder to act as an ambassador for SSfG, demonstrating exceptional leadership, strong stakeholder management and communication skills. Our vision is to free up civil servants to focus on what they do best: engaging with and delivering for citizens. We are looking for someone who can buy into that vision and then use their skills and expertise to make it a reality Job description The Shared Services for Government Strategy (SSfG) will transform and modernise the back office of Government. It brings together 18 different departments, and dozens of arms length bodies, into five clusters to replace around 200 departmental-based legacy IT systems with 5 modern, user-friendly, cloud-based systems. It will deliver smarter, cheaper, faster systems and processes to create a synchronised Civil Service, providing value and efficiency, process and common data standards and methodology. It will harness modern technology to deliver value for the taxpayer and improved experience for users. By standardising data and aligning policy and process across clusters we will improve the level of insight, and information available to government to underpin decision making. Respected in the sector, you will lead an expert team of technical shared service specialists and play a lead role in supporting clusters to design and implement their new shared service centres and business process support; providing expertise across the range of services required. As a senior leader within the Cabinet Office, Government People Group and SSfG, you will be expected to play a full role in the overall leadership of the Civil Service. You will lead the team, working collaboratively with departments, clusters and functions. Working to the SSfG senior leadership team and Director, the role will cover the following key responsibilities: Lead the implementation of the Shared Services Strategy for Government working with a wide community transforming the back office of Government Work closely with clusters engaged in in-flight migrations to cloud platforms to support them in taking advantage of best practice implementation approaches and technology, to enable successful delivery Lead an expert team of shared service specialists with in depth service and product knowledge Work closely with clusters to support the successful implementation of their GMPP programmes Horizon scan across the technical and business service provider sector to provide insights to support successful delivery Work with HMT's Functional Convergence Programme to drive synchronised data and standards across clusters. Further information Please note that this role requires SC clearance, which would normally need 5 years UK residency in the past 5 years. This is not an absolute requirement, but supplementary checks may be needed where individuals have not lived in the UK for that period. This may mean your security clearance (and therefore your appointment) will take longer or, in some cases, not be possible. Any move to Cabinet Office from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax Free Childcare. This role has a minimum assignment duration of 3 years. An assignment duration is the period of time a Senior Civil Servant is expected to remain in the same post to enable them to deliver on the agreed key business outcomes. The assignment duration also supports your career through building your depth of expertise. As part of accepting this role you will be agreeing to the expected assignment duration set out above. This will not result in a contractual change to your terms and conditions. Please note this is an expectation only, it is not something which is written into your terms and conditions or indeed which the employing organisation or you are bound by. It will depend on your personal circumstances at a particular time and business needs, for example, would not preclude any absence like family friendly leave. It is nonetheless an important expectation, which is why we ask you to confirm you agree to the assignment duration set out above. Security Successful candidates must undergo a criminal record check. Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check. People working with government assets must complete baseline personnel security standard checks. Working for the Civil Service The Civil Service Code sets out the standards of behaviour expected of civil servants. We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles. The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria. The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy. Apply and further information This vacancy is part of the Great Place to Work for Veterans initiative. Contact point for applicants"
        ],
        "url": [
          "https://jobs.theguardian.com/job/8644209/deputy-director-shared-service-design-and-cloud-transformation/?LinkSource=TopJob"
        ],
        "sax-email_addresses": [
          "[{[email protected], [email protected]}]"
        ],
        "companyId": [
          "DE8171037013"
        ],
        "minhash": [
          9032358769453118000
        ],
        "lang": [
          "en"
        ]
      },
      {
        "sax-apply_now_link": [
          "https://jobs.theguardian.com/apply/8653569/python-django-developer?LinkSource=JobDetails"
        ],
        "title": [
          "Python / Django Developer job with GET STAFFED ONLINE RECRUITMENT LIMITED | 8653569"
        ],
        "content": [
          "Job Details Experienced Python / Django Developer - Norwich Our client is a small but very successful web and bespoke software development studio based in Norwich. 2023 marks their 13th year of trading. Their roots were formed in providing web hosting and web development for small businesses across Norfolk, but over time their product offering has broadened, and their customer base has grown substantially across the globe. They are currently seeking a talented Python Developer that has commercial experience with the Django framework, and other related Python libraries and methodologies. The successful candidate will require a wide-ranging skill set, and will work closely with our client's experienced Lead Software Architect to take complex bespoke projects from conception and planning, prototyping, and development stages, and finally through to successful deployment and support. The ability and experience to provide realistic estimates is important within their small but successful business. Our client has successfully delivered a multitude of varied and large-scale bespoke projects, and offer a unique and laid-back working environment to get the best from their employees. Along with Python development, some other recent successful projects span App Development across iOS and Android, hardware EPOS integration, CRM and E-Commerce. Simply put, our client enjoys the challenge of successfully delivering varied, modern applications across a wide range of platforms, and the successful candidate must share this ambition. Responsibilities: Work with their small team to design and develop web and mobile applications. Ensure security, maintainability, scalability, and performance. Provide technical expertise in the areas of architecture, design, and implementation. Estimate project schedules accurately and consistently. Keep abreast of emerging technologies and trends. Required Skills: Minimum 2 years' commercial Python / Django experience Experience of using modern version control systems, e.g. git Knowledge of common open-source databases, such as PostgreSQL and MySQL/MariaDB Knowledge of modern architectures, including RESTful APIs and asynchronous queues Ability to understand complex project requirements and translate these into smaller, achievable project goals Confidence in communicating with colleagues and clients Desirable Skills: Understanding of fundamental frontend design and development, including HTML5, CSS and JavaScript Experience of using other common open-source Python libraries, including Django REST Framework and Celery Experience of using other backend frameworks and libraries, including NodeJS and SASS/Less Experience of using and configuring common Open Source web-servers, such as Apache2 and Nginx Salary from £40,000 pa but commensurate with experience. The right candidate will be expected to work from our clients offices, a 5 minute walk from the Norwich Train Station for those travelling by rail. Bus stops are outside the office and on site parking available for those that drive. There may be an opportunity to split work between home and the office for the right candidate but only upon successful completion of a probationary period. Normal hours: Mon - Fri, 9 - 5 but will consider the needs of candidates and their families. Company Here at Get Staffed we've been offering all the best bits of an agency whilst reducing your cost per hire since 2012. Our recruitment is online, but we aren't. A specialist account manager will be on hand at every step of the process. We use the largest and most effective job board network in the UK, putting your job in front of millions of candidates daily. Our innovative system tests candidates to ensure they are the best fit before you even interview them. Allowing you to read between the lines of a CV and find that perfect candidate. Allowing you to invest your time in only the best and most suitable candidates."
        ],
        "url": [
          "https://jobs.theguardian.com/job/8653569/python-django-developer/"
        ],
        "companyId": [
          "DE8171037013"
        ],
        "minhash": [
          6743922172162755000
        ],
        "sax-addresses": [
          "[{country=united kingdom, road=innovation way, city=bedford, state_district=bedfordshire, postcode=mk43 9sp, source=Innovation Way Bedford Bedfordshire MK43 9SP United Kingdom}]"
        ],
        "lang": [
          "en"
        ]
      },
      {
        "sax-phone_numbers": [
          "[{phone_number=+492343070536, source=+49 (0234) 30705-36}, {phone_number=+492343070536, source=0234 3070536}]"
        ],
        "title": [
          "2557270.pdf"
        ],
        "content": [
          "Bewerbungsfrist: 31.10.2023 Sozialarbeiter*in / Sozialpädagog*in Straffälligenhilfe (m/w/d) Der Ansprechpartner(in): Krischak, Markus Falls Sie Fragen zur Stelle haben, richten Sie diese bitte an den Dienstgeber bzw. die Ansprechpartner(in). Der Deutsche Caritasverband hat ausschließlich die technische Verantwortung für die Job- und Praktikumsbörse der Caritas in Deutschland. Vielen Dank!"
        ],
        "url": [
          "https://www.caritas-bochum.de/joboffer_document.ashx?id=8eb3b3b4-5d1b-4cee-a8e8-d8bbcdb3f181"
        ],
        "sax-email_addresses": [
          "[{[email protected], [email protected]}]"
        ],
        "companyId": [
          "DE4050125864"
        ],
        "minhash": [
          -8989558628270789000
        ],
        "sax-addresses": [
          "[{road=lohbergstr., city=bochum, postcode=44789, house_number=2a |, source=Dr. Markus Krischak Caritasverband Ruhr-Mitte e.V. Betreuungsverein und Freie Straffälligenhilfe Lohbergstr. 2a | 44789 Bochum, house=dr. markus krischak caritasverband ruhr-mitte e.v. betreuungsverein und freie straffälligenhilfe}, {road=huestraße, city=bochum, postcode=44787, house_number=15, source=Huestraße 15 44787 Bochum}, {road=lohbergstr., city=bochum, postcode=44789, house_number=2 a, source=Caritasverband für Bochum und Wattenscheid e.V. SKM - Betreuungsverein und Freie Straffälligenhilfe Lohbergstr. 2 a 44789 Bochum, house=caritasverband für bochum und wattenscheid e.v. skm betreuungsverein und freie straffälligenhilfe}]"
        ],
        "lang": [
          "de"
        ]
      },
      {
        "sax-phone_numbers": [
          "[{phone_number=+492345305361152, source=0234 / 5305361-152}, {phone_number=+492345305361152, source=+49 (0234) 5305361-152}]"
        ],
        "title": [
          "2542823.pdf"
        ],
        "content": [
          "Bewerbungsfrist: 15.10.2023 Mitarbeitende*n für die Pflege (m/w/d) Der Caritasverband Ruhr-Mitte e.V. ist der anerkannte örtliche Wohlfahrtsverband der katholischen Kirche. Unsere Hilfen erstrecken sich über Einrichtungen der Kinder-, Jugend- und Familienhilfe, über Beratungs- und Betreuungsdienste bis hin zu ambulanten, teilstationären und stationären Pflegeeinrichtungen sowie Suchtkrankenhilfe und existenzielle Hilfen. Wir suchen ab 01.11.2023 für unser "Blomenberg-Haus", einer stationären "Einrichtung der Besonderen Wohnform" für 20 alkoholerkrankte, abstinent lebende Menschen, eine/n Mitarbeitende*n Pflege (w/m/d) in Teilzeit (19,5 Wochenstunden). Das "Blomenberg-Haus" ist eine stationäre Einrichtung im Rahmen der Eingliederungshilfe. Unser Ziel ist es, in einem suchtmittelfreien Raum und mit einem multiprofessionellen Team das Leben der Bewohner*innen zu sichern, den geistigen, seelischen und körperlichen Zustand zu stabilisieren, nach Möglichkeit zu verbessern und ihnen ein menschenwürdiges Dasein zu ermöglichen. Ziel ist es auch, einzelne Bewohner*innen in ein Leben außerhalb des stationären Rahmens zu begleiten. Ihre Aufgaben  Sicherstellung der Gesundheitsversorgung unserer Bewohner*innen  Unterstützung und Motivierung der Bewohner*innen im Rahmen medizinischer Fragestellungen  Stellen von Medikamenten und Medikamentenausgabe  Umsetzung der gesetzlichen Rahmenbedingungen  fachgerechte Dokumentation  Teilnahme an Dienstbesprechungen Wir erwarten 2  eine examinierte Pflegekraft im Bereich Gesundheits-und Krankenpflege / Altenpflege, Berufserfahrung wünschenswert (nicht notwendigerweise im Bereich Sucht- oder Abhängigkeitserkrankung)  Empathie und soziale Kompetenz  Verantwortungsbewusstsein und Engagement  Teamfähigkeit  Bereitschaft zur Arbeit im Schichtdienst und gelegentlich an Wochenenden   Wir bieten  einen sicheren Arbeitsplatz mit einer verantwortungsvollen Tätigkeit  Mitarbeit in einem vorhandenen Pflegeteam, Zusammenarbeit und Austausch mit den Kolleg*innen der anderen Professionen  verlässliche Dienstplanung  eine attraktive Vergütung gemäß AVR-Caritas mit Jahressonderzahlungen  betriebliche Zusatzversorgung  Förderung von Fort- und Weiterbildungen  JobRad-Leasing und Zuschuss zum DeutschlandTicket  Team-Supervisionen. Merkmale Befristung: unbefristet Umfang: Teilzeit Arbeitsfeld 1: Menschen in schwierigen Lebenslagen, Menschen mit Behinderung Arbeitsfeld 2: Hauswirtschaft und Service Funktion: Fachkraft Job besonders für Menschen mit Behinderung geeignet: Keine Angabe Weitere Angaben Bitte senden Sie Ihre aussagekräftigen Bewerbungsunterlagen - bevorzugt online - an: E-Mail: 3 Bitte beachten Sie, dass Ihre Bewerbung die Größe von 8 MB nicht überschreitet. Telefonische Auskunft ist möglich unter: Wir schätzen die Vielfalt und freuen uns besonders über Bewerbungen geeigneter schwerbehinderter Menschen. Kontaktdaten Dienstgeber: Caritasverband Ruhr-Mitte e.V. Dienstort: Blomenberg-Haus Sozialtherapeutisches Wohnheim für chronisch abhängigkeitskranke Menschen Alte Wittener Str. 21 44803 Bochum Ansprechpartner(in): Kahlert, Thomas Falls Sie Fragen zur Stelle haben, richten Sie diese bitte an den Dienstgeber bzw. die Ansprechpartner(in). Der Deutsche Caritasverband hat ausschließlich die technische Verantwortung für die Job- und Praktikumsbörse der Caritas in Deutschland. Vielen Dank!"
        ],
        "url": [
          "https://www.caritas-bochum.de/joboffer_document.ashx?id=f50d6a18-5fa3-42c2-aad1-5611061f22d8"
        ],
        "sax-email_addresses": [
          "[{[email protected], [email protected]}, {[email protected], [email protected]}]"
        ],
        "companyId": [
          "DE4050125864"
        ],
        "minhash": [
          6205455054080464000
        ],
        "sax-addresses": [
          "[{road=alte wittener straße, city=bochum, postcode=44803, house_number=21, source=Herrn Thomas Kahlert Blomenberg-Haus Alte Wittener Straße 21 44803 Bochum, house=herrn thomas kahlert blomenberg-haus}, {road=huestraße, city=bochum, postcode=44787, house_number=15, source=Huestraße 15 44787 Bochum}]"
        ],
        "lang": [
          "de"
        ]
      },
      {
        "sax-phone_numbers": [
          "[{phone_number=+492345305361152, source=0234 / 5305361-152}, {phone_number=+492345305361152, source=+49 (0234) 5305361-152}]"
        ],
        "title": [
          "2545723.pdf"
        ],
        "content": [
          "Bewerbungsfrist: 31.10.2023 Mitarbeitende für den Nachtdienst (w/m/d) Der Caritasverband Ruhr-Mitte e.V. ist der anerkannte örtliche Wohlfahrtsverband der katholischen Kirche. Unsere Hilfen erstrecken sich über Einrichtungen der Kinder-, Jugend- und Familienhilfe, über Beratungs- und Betreuungsdienste bis hin zu ambulanten, teilstationären und stationären Pflegeeinrichtungen sowie Suchtkrankenhilfe und existenzielle Hilfen. Wir suchen zum nächstmöglichen Termin für unser "Blomenberg-Haus", einer stationären "Einrichtung der Besonderen Wohnform" für alkoholkranke, abstinent lebende Menschen, Mitarbeitende für den Nachtdienst (w/m/d) in Teilzeit (19,5 Wochenstunden). Das "Blomenberg-Haus" ist eine stationäre Einrichtung im Rahmen der Eingliederungshilfe. Das Ziel ist hier, in einem suchtmittelfreien Raum und mit einem multiprofessionellen Team das Leben der Bewohner*innen zu sichern, den geistigen, seelischen und körperlichen Zustand zu stabilisieren, nach Möglichkeit zu verbessern und ihnen ein menschenwürdiges Dasein zu ermöglichen. Ziel ist es auch, einzelne Bewohner*innen in ein Leben außerhalb des stationären Rahmens zu begleiten. Ihre Aufgaben  Begleitung und Betreuung der Bewohner*innen in den Nachmittags- und (schwerpunktmäßig) in den Abendstunden, Bereitschaftsdienst "vor Ort" ab 22.30 Uhr (Schlafbereitschaft)  Unterstützung und Motivierung der Bewohner*innen im Rahmen der Freizeitgestaltung  Medikamentenausgabe  Übernahme von pflegerischen und hauswirtschaftlichen Tätigkeiten  fachgerechte Dokumentation  Teilnahme an Dienstbesprechungen 2 Wir erwarten Ihr Profil:  Fachkraft (z.B. Altenpfleger*in, Gesundheits- und Krankenpfleger*in, Kinderkrankenpfleger*in, Heilerziehungspfleger*in, Sozialarbeiter*in, Sozialpädagog*in, Heilpädagog*in, Erzieher*in, Ergo-, Physio- oder Sprachtherapeut*in, oder Mitarbeitende mit gleichwertigen staatlich anerkannten Berufsabschlüssen), Berufserfahrung wünschenswert.  Empathie und soziale Kompetenz  Verantwortungsbewusstsein und Engagement  Teamfähigkeit Wir bieten  einen sicheren Arbeitsplatz mit einer verantwortungsvollen Tätigkeit  eine attraktive Vergütung gemäß AVR-Caritas mit Jahressonderzahlungen  betriebliche Zusatzversorgung  Förderung von Fort- und Weiterbildungen  JobTicket und JobRad  Möglichkeit zur Teilnahme an Team-Supervisionen Merkmale Befristung: befristet, unbefristet Umfang: Teilzeit Arbeitsfeld 1: Menschen in schwierigen Lebenslagen Funktion: Fachkraft Job besonders für Menschen mit Behinderung geeignet: Keine Angabe Weitere Angaben Bitte senden Sie Ihre aussagekräftigen Bewerbungsunterlagen - bevorzugt online - an: 3 Bitte beachten Sie, dass Ihre Bewerbung die Größe von 8 MB nicht überschreitet. Telefonische Auskunft ist möglich unter: Schwerbehinderte Menschen werden bei gleicher fachlicher Qualifikation und Eignung bevorzugt eingestellt. Kontaktdaten Dienstgeber: Caritasverband Ruhr-Mitte e.V. Dienstort: Blomenberg-Haus Sozialtherapeutisches Wohnheim für chronisch abhängigkeitskranke Menschen Alte Wittener Str. 21 44803 Bochum Ansprechpartner(in): Kahlert, Thomas Falls Sie Fragen zur Stelle haben, richten Sie diese bitte an den Dienstgeber bzw. die Ansprechpartner(in). Der Deutsche Caritasverband hat ausschließlich die technische Verantwortung für die Job- und Praktikumsbörse der Caritas in Deutschland. Vielen Dank!"
        ],
        "url": [
          "https://www.caritas-bochum.de/joboffer_document.ashx?id=f5ea6573-5892-4b56-b307-95f8820bf07f"
        ],
        "sax-email_addresses": [
          "[{[email protected], [email protected]}]"
        ],
        "companyId": [
          "DE4050125864"
        ],
        "minhash": [
          5160056989377512000
        ],
        "sax-addresses": [
          "[{road=alte wittener straße, city=bochum, postcode=44803, house_number=21, source=Herrn Thomas Kahlert Blomenberg-Haus Alte Wittener Straße 21 44803 Bochum, house=herrn thomas kahlert blomenberg-haus}, {road=huestraße, city=bochum, postcode=44787, house_number=15, source=Huestraße 15 44787 Bochum}]"
        ],
        "lang": [
          "de"
        ]
      }
    ]
  }
}

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:1,32.1
  • **Database (default: SQLite):SQLite
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):Own
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):npm
  • **Operating system:AWS AMI 2023

hello @Kool_Baudrillard

As your input is not properly formatted JSON, we will need some regex magic to fix that.