Capturing xp_cmdshell JSON output into a parameter.

  • Hey guys, I'm trying to capture a JSON output of xp_cmdshell command, and the parse is using OPENJSON command with the variable. I'm having difficultly capturing JSON though, as the only way I can do it right now is to create a temp table, and insert into it. However then I get a bunch of rows, so I can't parse it as JSON. I can probably stitch it all back together, but there's gotta be a more elegant solution for this.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply