Receive a JSON message and call a SQL procedure

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

anonymous user

Anonymous

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

Comments

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

tmcgrath gravatar imagetmcgrath ( 2018-01-23 16:00:23 -0600 )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 -0600 )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 -0600 )edit