Ask Your Question
0

I am using HTTP server as origin and destination is local FS. My data is originating in "json" and need to in SQL format at destination or any readable So what Processor need to add.

asked 2018-09-17 00:21:46 -0600

Ashwani gravatar image

I am using HTTP server as origin and destination is local FS. My data is originating in "json" and need to in SQL format at destination or any readable So what Processor need to add.

edit retag flag offensive close merge delete

3 Answers

Sort by ยป oldest newest most voted
1

answered 2018-10-01 10:11:24 -0600

iamontheinet gravatar image

updated 2018-10-01 10:29:24 -0600

Hi!

You can use JDBC Producer to store data in SQL format.

For example, to store JSON data originating from HTTP server into MySQL, here's the pipeline setup:

image description

image description

In this case, issuing HTTP post curl -d '{"name":"dash"}' -H "Content-Type: application/json" -H "X-SDC-APPLICATION-ID: sdc" -X POST http://localhost:6000/ will insert a new record in MySQL table test and set column pname to "dash".

Cheers, Dash

edit flag offensive delete link more
0

answered 2018-10-01 10:11:30 -0600

metadaddy gravatar image

Configure the HTTP Server origin with JSON data format - that will parse the incoming data into fields. You can then map those fields into your database columns in the JDBC Producer destination.

edit flag offensive delete link more
0

answered 2018-10-01 08:28:37 -0600

Alexander gravatar image

You can try to use jquery

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-17 00:21:46 -0600

Seen: 51 times

Last updated: Oct 01