I have a page (ASP classic) which has a recordset with data.
recordset name: rs_contact
This is the first time I will be doing this so a good explanation would be very much appreciated.
I need to pass this data to a JSON format so that I can the post it to an URL (to be used by an API)
The page is in classic ASP. The data I need to pass is in the format below. This considering I only got one result in my recordset and the values returned are:
FirstNm = 'Aleks'
LastNm = 'Demo'
email = 'email@example.com'
Those values somehow need to be turned into this JSON
We have to consider there may be more than one result from the recordset, another set of values would be:
This is the JSON file example I have to create:
Once this is created I need to post the data to an URL that is also stored in a recordset.
The URL will require a token as parameter, so I need to pass 2 parameters, the first part is the URL and the second is the token.
something like: https://<%=url("value")%>?token?<%=token("value")%>
We can break this down in those two parts. One is taking the recordset info and converting it into JSON. And the second part is posting this JSON to the URL.