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:
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,