Receive a JSON message and call a SQL procedure

asked 2018-01-23 12:41:07 -0500

anonymous user


I'm receiving a JSON message but I'm having trouble sending the JSON message to my SQL Server procedure as text:

EXEC sp_Receive NULL,NULL,NULL, '${??????????????????????}'

RabbitMQ Consumer -> StreamSelector ->JDBS Query executor

It seems I've seen some step between the StreamSelector and JDBS Query but not sure. So basically how to I reference the json object in the JDBS Query component to call a sql procedure with the field as text?

edit retag flag offensive close merge delete


have you tried running in Preview mode to review data between each stage?

tmcgrath gravatar imagetmcgrath ( 2018-01-23 16:00:23 -0500 )edit

I have and the puzzling thing is that when I select text as the data format there are formatting added that I think is causing the problem now. Where is all the “Field[MAP:{“ and “STRING:” additions coming from. I do not what this added to the text output. Do you know how I could remove them?

ZDG gravatar imageZDG ( 2018-01-24 09:08:06 -0500 )edit

In recreating it I thought there was a component used to produce the json in a normal (without all the MAP: and STRING additions) text field. Original json message: { "eventId": "123", … “converted” json: Field[MAP:{text=Field[STRING: "eventId": "123",]}],

ZDG gravatar imageZDG ( 2018-01-24 09:11:07 -0500 )edit