February 7, 2023 at 1:47 pm
I have response from a API that look like
{
"responseCode": 200,
"message": "success",
"content": [
{
"id": "1234578",
"form_id": "9v5648148",
"created_at": "2023-01-31 14:54:37",
"status": "ACTIVE",
"answers": {
"1": {
"name": "name",
"order": "2",
"sublabels": "{\"prefix\":\"Prefix\",\"first\":\"First Name\",\"middle\":\"Middle Name\",\"last\":\"Last Name\",\"suffix\":\"Suffix\"}",
"text": "Name",
"type": "control_fullname",
"answer": {
"first": "First",
"last": "LastTest"
},
"prettyFormat": "First LastTest"
},
"2": {
"name": "10Digit1234",
"order": "3",
"text": "Enter Control number",
"type": "control_textbox",
"answer": "1234567809"
}
},
{
"id": "5510025870127903",
"form_id": "9v56481481",
"created_at": "2023-01-31 14:29:47",
"status": "ACTIVE",
"updated_at": null,
"answers": {
"1": {
"name": "name",
"order": "2",
"sublabels": "{\"prefix\":\"Prefix\",\"first\":\"First Name\",\"middle\":\"Middle Name\",\"last\":\"Last Name\",\"suffix\":\"Suffix\"}",
"text": "Name",
"type": "control_fullname",
"answer": {
"first": "Test1",
"last": "Test2"
},
"prettyFormat": "Test Test2"
},
"2": {
"name": "10Digit1234",
"order": "3",
"text": "Enter Control number",
"type": "control_textbox",
"answer": "11111111"
}
}
],
"duration": "235.75ms",
"resultSet": {
"offset": 0,
"limit": 20,
"count": 20
},
"limit-left": 9990
}
how do i convert this to SQL table data..
February 7, 2023 at 5:34 pm
Sorry, but that's not valid JSON.
Generally, what most people do, is to flatten the structured JSON into one table, which can later be queried and grouped.
Alternatively you can also use for example an SSIS script component to deserialize it into several output tables, that reflect the structure of the JSON input. But generally that's a more involved process.
February 8, 2023 at 8:58 am
This was removed by the editor as SPAM
February 17, 2023 at 6:02 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy