Write a Python script to parse a semi-structured JSON payload from a third-party property data provider and flatten it into a relational format.
