Kafka Trigger Node - deserialize Avro

Hi, anyone experience with Kafka Nodes and deserializing AVRO to json?

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.51.0
  • **Database (default: SQLite):Psotgres
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):OWN
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):NPM
  • **Operating system:AWS AMI 2023

Hi @Kool_Baudrillard,

Not in particular, but let’s have a go at it :slight_smile:

What have you got so far, and what happened when you tried it?

Hi,

i have the Kafka trigger node, an event is triggered.

json looks like this:

[
{
“message”: “\u0000\u0000\u0000\n�H5b859d6b-1a30-4b14-a2b4-a8f32f607974"NewCrawledListing\bV1_02marketing_data_automation\u0012sXXX\u001eXXXglobal\fglobalг�ߘd����d\u0000\u0000\u0000\u0000\u0000\u0002г�ߘd�\u0001https://careers.atkinsrealis.com/fr/Workflow?workflowId=8ba1e295-c173-4fab-17f1-08d6ccb74177&vacancyId=38842\u0001&Procurement Manager\u0000\u0000\u0000�?��\u0001

\nQui sommes-nous\n\n

\n

\nNous sommes une organisation de calibre mondial de services d’ingénierie et d’énergie nucléaire. Nous lions individus, données et technologie pour transformer les infrastructures et les systèmes énergétiques du monde. Ensemble, avec nos partenaires, nos clients et notre équipe mondiale de consultants, concepteurs, ingénieurs et gestionnaires de projet, nous pouvons changer le monde.\n<br clear="none">
<br clear="none">
\n

\n

\nCe que nous faisons\n\n

\n

\nDe la conception de villes entières à la construction de centrales nucléaires, nous nous concentrons sur des domaines qui améliorent grandement la façon dont nous sommes logés, connectés, alimentés en énergie et protégés.\n\n

\n

\n Why work for AtkinsRéalis?\n

\n

\nWe at AtkinsRéalis are committed to developing its people both personally and professionally. Our colleagues have the advantage of access to a high ranging training portfolio and development activities designed to help make the best of individual’s abilities and talents. We also actively support staff in achieving corporate membership of relevant institutions.\n\n

\n

\n Meeting Your Needs\n

\n

\nTo help you get the most out of life in and outside of work, we offer employees ‘Total Reward’.\n\n

\n

\nMaking sure you’re supported is important to us. So, if you identify as having a disability, tell us ahead of your interview, and we’ll discuss any adjustments you might need.\n\n

\n

\n Additional Information\n

\n

\nWe are an equal opportunity, drug-free employer <br clear="none">
Procurement Manager:.\n

\n

\nJob Description\n\n

\n

\nThis role is an exciting career opportunity for those of you who has 8-10 years experience in construction procurement role. As a Procurement Engineer you will be mainly supporting for project team in onboarding vendors for various projects.\n

\n

\nTo succeed in this role, you will need to pay attention to details, stay organized and support tasks related to procurement process.\n\n

\n

\n Responsibilities\n

\n
  • \nSupport Project team in entire procurement process.\n\n
  • \n
  • \nBoQ preparation and cost plan for all RIBA stages\n\n
  • \n
  • \nPerforming all procurement activities including pre-qualification, Tender documentation, preparation of contracts and tender management, negotiating supplier agreements.\n\n
  • \n
  • \nInvolve in Market Testing and bring best value to the project\n\n
  • \n
  • \nManage the vendor management platform to ensure compliance information is up to date.\n\n
  • \n
  • \nTender Evaluation and Recommendation.\n\n
  • \n
  • \nActively support the supplier onboarding process.\n\n
  • \n
  • \nIdentify process/system improvements opportunities and participate in their implementation.\n\n
  • \n
  • \nPerform root cause analysis and identify solutions.\n\n
  • \n
  • \nSupport Project Managers for project performance feedback based on their service delivery.\n\n
  • \n

    \n Requirements\n

    \n
  • \nBachelor’s degree in engineering preferred.\n\n
  • \n
  • \nCharteredship in any institution is added advantage.\n\n
  • \n
  • \nExtensive experience in different types of Building sector.\n\n
  • \n
  • \nBasic knowledge construction project life cycle.\n\n
  • \n
  • \nExcellent knowledge of Microsoft Office Suite (Excel, Word and PowerPoint required).\n\n
  • \n
  • \nBasic knowledge of Microsoft Power BI is a plus.\n\n
  • \n
  • \nOutstanding organizational skills.\n\n
  • \n
  • \nOutstanding communication skills, both written and verbal.\n\n
  • \n
  • \nExcellent reading and comprehension skills.\n\n
  • \n
  • \nProficient ability to detect errors, inconsistencies and identify trends in data.\n\n
  • \n
  • \nProficient in project related letter correspondences.\n\n
  • \n
  • \nExperience of working with multiple stakeholders.\n\n
  • \n
  • \nCan build relationships effectively with Clients.\n\n
  • \n
  • \nEffective communication at all levels.\n\n
  • \n
  • \nAble to set priorities and complete multiple tasks simultaneously.\n\n
  • \n
  • \nStrong ability in negotiation.\n\n
  • \n
  • \nKnowledge in standard form of contracts. (FIDIC/JCT/NEC)\n\n
  • \n

    \n Skills\n

    \n
  • \nProficiency in English\n\n
  • \n
  • \nStrong team player.\n\n
  • \n
  • \nHighly autonomous, proactive and self-starter.\n\n
  • \n
  • \nAttention to details paired with good analytical abilities.\n\n
  • \n
  • \nStrong Client presentation.\n\n
  • \n
  • \nGood communication skills.\n\n
  • \n
  • \nKnowledge in standard method of measurements (POMI/NRM/SMM/IS1200) and measurement tools like Auto CAD, Cost X\n\n
  • \n
  • \nWork experience in a shared services, process driven or service center environment is a plus.\n\n
  • \n
  • \nResults orientated, driven by value added and business sustainability.\n\n
  • \n
  • \nShares best practices and learns from others.\n\n
  • \n

    \n Why work for AtkinsRéalis?\n

    \n

    \nWe at AtkinsRéalis are committed to developing its people both personally and professionally. Our colleagues have the advantage of access to a high ranging training portfolio and development activities designed to help make the best of individual’s abilities and talents. We also actively support staff in achieving corporate membership of relevant institutions.\n\n

    \n

    \n Meeting Your Needs\n

    \n

    \nTo help you get the most out of life in and outside of work, we offer employees ‘Total Reward’.\n\n

    \n

    \nMaking sure you’re supported is important to us. So, if you identify as having a disability, tell us ahead of your interview, and we’ll discuss any adjustments you might need.\n\n

    \n

    \n Additional Information\n

    \n

    \nWe are an equal opportunity, drug-free employer committed to promoting a diverse and inclusive community - a place where we can all be ourselves, thrive and develop. To help embed inclusion for all, from day one, we offer a range of family friendly, inclusive employment policies, flexible working arrangements and employee networks to support staff from different backgrounds. As an Equal Opportunities Employer, we value applications from all backgrounds, cultures, and ability.\n

    \n \u0012text/htmlvProcurement Manager job in Bangalore | AtkinsRéalis French\u0000\u0000�?�XQui sommes-nous Nous sommes une organisation de calibre mondial de services d’ingénierie et d’énergie nucléaire. Nous lions individus, données et technologie pour transformer les infrastructures et les systèmes énergétiques du monde. Ensemble, avec nos partenaires, nos clients et notre équipe mondiale de consultants, concepteurs, ingénieurs et gestionnaires de projet, nous pouvons changer le monde. Ce que nous faisons De la conception de villes entières à la construction de centrales nucléaires, nous nous concentrons sur des domaines qui améliorent grandement la façon dont nous sommes logés, connectés, alimentés en énergie et protégés. Why work for AtkinsRéalis? We at AtkinsRéalis are committed to developing its people both personally and professionally. Our colleagues have the advantage of access to a high ranging training portfolio and development activities designed to help make the best of individual’s abilities and talents. We also actively support staff in achieving corporate membership of relevant institutions. Meeting Your Needs To help you get the most out of life in and outside of work, we offer employees ‘Total Reward’. Making sure you’re supported is important to us. So, if you identify as having a disability, tell us ahead of your interview, and we’ll discuss any adjustments you might need. Additional Information We are an equal opportunity, drug-free employer committed to promoting a diverse and inclusive community - a place where we can all be ourselves, thrive and develop. To help embed inclusion for all, from day one, we offer a range of family friendly, inclusive employment policies, flexible working arrangements and employee networks to support staff from different backgrounds. As an Equal Opportunities Employer, we value applications from all backgrounds, cultures, and ability. Procurement Manager: Job Description This role is an exciting career opportunity for those of you who has 8-10 years experience in construction procurement role. As a Procurement Engineer you will be mainly supporting for project team in onboarding vendors for various projects. To succeed in this role, you will need to pay attention to details, stay organized and support tasks related to procurement process. Responsibilities Support Project team in entire procurement process. BoQ preparation and cost plan for all RIBA stages Performing all procurement activities including pre-qualification, Tender documentation, preparation of contracts and tender management, negotiating supplier agreements. Involve in Market Testing and bring best value to the project Manage the vendor management platform to ensure compliance information is up to date. Tender Evaluation and Recommendation. Actively support the supplier onboarding process. Identify process/system improvements opportunities and participate in their implementation. Perform root cause analysis and identify solutions. Support Project Managers for project performance feedback based on their service delivery. Requirements Bachelor’s degree in engineering preferred. Charteredship in any institution is added advantage. Extensive experience in different types of Building sector. Basic knowledge construction project life cycle. Excellent knowledge of Microsoft Office Suite (Excel, Word and PowerPoint required). Basic knowledge of Microsoft Power BI is a plus. Outstanding organizational skills. Outstanding communication skills, both written and verbal. Excellent reading and comprehension skills. Proficient ability to detect errors, inconsistencies and identify trends in data. Proficient in project related letter correspondences. Experience of working with multiple stakeholders. Can build relationships effectively with Clients. Effective communication at all levels. Able to set priorities and complete multiple tasks simultaneously. Strong ability in negotiation. Knowledge in standard form of contracts. (FIDIC/JCT/NEC) Skills Proficiency in English Strong team player. Highly autonomous, proactive and self-starter. Attention to details paired with good analytical abilities. Strong Client presentation. Good communication skills. Knowledge in standard method of measurements (POMI/NRM/SMM/IS1200) and measurement tools like Auto CAD, Cost X Work experience in a shared services, process driven or service center environment is a plus. Results orientated, driven by value added and business sustainability. Shares best practices and learns from others. Why work for AtkinsRéalis? We at AtkinsRéalis are committed to developing its people both personally and professionally. Our colleagues have the advantage of access to a high ranging training portfolio and development activities designed to help make the best of individual’s abilities and talents. We also actively support staff in achieving corporate membership of relevant institutions. Meeting Your Needs To help you get the most out of life in and outside of work, we offer employees ‘Total Reward’. Making sure you’re supported is important to us. So, if you identify as having a disability, tell us ahead of your interview, and we’ll discuss any adjustments you might need. Additional Information We are an equal opportunity, drug-free employer committed to promoting a diverse and inclusive community - a place where we can all be ourselves, thrive and develop. To help embed inclusion for all, from day one, we offer a range of family friendly, inclusive employment policies, flexible working arrangements and employee networks to support staff from different backgrounds. As an Equal Opportunities Employer, we value applications from all backgrounds, cultures, and ability.�\u0001https://careers.atkinsrealis.com/fr/job/procurement-manager-in-bangalore-jid-38842\u0000\u0016GBML1089745\u0000���������\u0001����\u000f��\u001d0careers.atkinsrealis.com�\u0001https://careers.atkinsrealis.com/fr/job/procurement-manager-in-bangalore-jid-38842\u0004enг�ߘd”,
    “topic”: “dd-com-XXXX-daas-schema-entities-mda-crawlflow-crawledlistingevent-v1-events”
    }
    ]

    ok, looks like it´s a Kafkajs issue and how it handles long type.

    :-/

    This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.