Because some cases were available at more than one URL, there are duplicates in the output. We were going to use OFT's Ref field to de-dupe, but this field was removed from the spreadsheets.
Report on them to start with, and see if there's a strategy for removing them. If they occur in markets or mergers, they'll have a body generated for them, but if they occur elsewhere, they won't - so prefer markets or mergers in those cases.
Closing, as from a preliminary report I can't see that this is a problem - we're only taking JSON with "modified_by_sheet": true, and these duplicates occur in JSON not modified by the sheets.
Because some cases were available at more than one URL, there are duplicates in the output. We were going to use OFT's
Ref
field to de-dupe, but this field was removed from the spreadsheets.Report on them to start with, and see if there's a strategy for removing them. If they occur in markets or mergers, they'll have a body generated for them, but if they occur elsewhere, they won't - so prefer markets or mergers in those cases.