Would someone please help me understand how to deal with JSON responses in the import mapper?
JSON has a variable schema, so one record/JSON Object might have 3 key values, and the next Object might only have 2.
If I map all 3 keys to database columns, then when that second object tries to insert into the table it shifts my 3rd column value to my second column (assuming the first or second key was missing from that second JSON Object).
Please help me understand how to deal with these types of changes that are common in JSON Responses.
Please sign in to leave a comment.