PAssing JSON to a stored Procedure

Question

I am not sure how this works.  I simply want to pass a JSON from the builder to a stored procedure as a parameter.

Any thoughts?

geraldo · Answer

@danmeland

the raw json is usually on just one line. In the batch macro you place a parameters tool and an action and replace the parameter that you have to pass in the procedure

danmeland · Answer

ok the flow senerio is to query a web service, retrieve the JSON, cleanse it, then pass it through to a Sql Server stored procedure.

Seems quit simple, but I just cant rap my head around it.  The parameter will retain the same name each time, but how is the json string passed?

Thanks in advanced

geraldo · Answer

@danmeland

Could you send an example.
I believe that through the batch macro you can pass this parameter in presql or post sql to execute the procedure