JSON Input dynamic Schema

Six Stars

JSON Input dynamic Schema

Hello,

 

Working in Talend Open Studio 6.4.

I need to work with a JSON as input file, which I get as response from an API.

However, the schema of this JSON may change from one request to another. 

Is there a way to make the JSON input schema dynamic?

I know of tJsonnormalize, but according to docuentation it is only compatible up to 5.6 version. 

Any Ideas are welcome.

 

Regards,

Forteen Stars

Re: JSON Input dynamic Schema

what is "dynamic" in Your schema?
and what finally You try to achieve ?

-----------
Six Stars

Re: JSON Input dynamic Schema

Hello,

pretty much every thing is dynamic.

It's a template for profile creation send by an API. The number of fields varies. While some are standard, their position may varies. Some exist in one file and may not exists in another....

From this template and a csv file containing actual data, I'll create my users in API.

I can certainly define one schema for one instance, but for next run, the schema will be different, and for the next as well, and so on

Regards,

Four Stars

Re: JSON Input dynamic Schema

Hi Chillion,

I have the same requirement, did you resolve this ?

If yes, Can you please provide the steps .

 

Thanks & Regards,

Madhu Kolli

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Talend Cloud Developer Series – Fetching Studio License

This video will help someone new to using Talend Studio get started by connecting to Talend Cloud and fetching the Studio License

Watch Now

Talend Cloud Developer Series - Introduction

The Talend Cloud Developer Series was created to give you a solid foundational understanding of Talend’s Cloud Integration Platform

Watch Now

Talend Cloud Available on Microsoft Azure

An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources

Watch Now