Process Json request to my SQL Stored Procedure

[Robert Morton]

I am trying to figure out how I can handle a json post from a 3rd
party. They are sending me a json post with 3 variables to a url I
host. I will use the 3 variables sent to process an SQL Stored
Procedure call to my SQL Server. Once the SQL SP is completed the
Return Value is what the 3rd parties Json post will wait for (the
return value from the SQL server will tell the 3rd parties json post
that the process was a success or failure).

I currently have everything working fine using standard Querystring
Values that were posted to my classic ASP page that executes the SQL
SP. I need some help with getting this process to work with json
values that are posted to the url instead of standard Querystring
values. They are sending me the values in json and awaiting a reply.
I think I need a way to get the json values, dim them, and be able to
use them in my classic asp SQL stored procedure call. Then the Stored
Procedure Return Value can be the reply that their json reply is
pending.


Could someone please point me in the right direction. Any assistance
would be great on how I can accomplish this.

[Guillermo Pérez]

You have to parse the json... here's a good parser: http://json.org/, look for the ASP section.


Guillermo y Silvia

www.LecturaBiblica.com

> Date: Thu, 11 Aug 2011 20:18:21 -0700
> Subject: Process Json request to my SQL Stored Procedure
> From: mor...@gmail.com
> To: asp...@googlegroups.com
> CC: rmo...@loftygolf.com