Ask Your Question

How to Join HTTP client Origin and Http client Processor data.

asked 2018-06-26 06:52:54 -0500

Kumar gravatar image

I have two APIs which gives two tables data. I am getting those two apis data with Http Origin and Http Client, Now i want Join those two apis data with a column column. How can I achieve this. --Thanks

edit retag flag offensive close merge delete


Please provide more details -- what does your pipeline look like? what's your destination? what format is the data coming in and stored as? etc.

iamontheinet gravatar imageiamontheinet ( 2018-06-26 10:55:34 -0500 )edit

The data is getting in CSV format. The data looks like below, API One PNAME PID ABC 1 DEF 2 API Two VALUE PID 111 1 222 2 Need to join two apis data with PID as join column

Kumar gravatar imageKumar ( 2018-06-27 00:05:34 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2018-06-27 18:30:33 -0500

iamontheinet gravatar image

I'd suggest you create two pipelines and store the data into a database (for example) using JDBC Producer destination and then perform joins.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-26 06:52:54 -0500

Seen: 411 times

Last updated: Jun 26 '18