- Wilko Lindemann
- .NET DataStore
- Tuesday, 9 February 2021 07:57 AM UTC
Hi,
I'm looking for a way to generate data in a specific JSON format to sent it to a unknown web server.
I have two tables (table1 with column1, column2, column3 and table2 with column2, column4). The table1 has a foreign key to table2 (column2).
The JSON should look like:
{
"column1": "xxx",
"table2": {
"column2": 1
},
"column3": "xxx"
}
So the requirements are:
1. the data of the foreign key must be in a extra segment
2. only the primary key of table2 should be part of the extra segment
3. NULLvalues should be ignored
Suggestions, guidance, and samples are welcome and appreciated!
Thanks and regards,
Wilko Lindemann
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.