Sunsetting Dropbox Forms

[Betree]

Tasks

Beta Give feedback

1. Release internal tax form system #7362
   6 of 6
   +0
   
2. Import Dropbox Forms data into Open Collective #7299
   api task team +3
   
3. Make sure we don't have any pending tax form requests on Dropbox forms anymore
4. Remove all code from the API (incl TAX_FORMS_USE_INTERNAL flag)
5. Move 40-send-tax-form-requests to a daily job
6. Remove TAX_FORMS_USE_LEGACY from frontend
7. Make a final backup of all the data on the account (see the script below)
8. Close the account

To backup data from Dropbox Forms:

start_date="2019-01-01T00:00:00.000Z"
end_date="2019-05-01T23:59:59.000Z"
end_loop_date=$(date -u +"%Y-%m-%dT00:00:00.000Z")
interval="4 months"
workflows="&guid[]=MfmOZErmhz1qPgMp&guid[]=qdUbX5nw8sMZzykz&guid[]=MkFBvG39RIA61OnD"

# Download
while [[ "$start_date" < "$end_loop_date" ]]; do
  # Calculate the end date for this period
  period_end_date=$(date -d "$start_date + $interval" "+%Y-%m-%dT%H:%M:%S.000Z")

  # Call the curl command with the current date range
  # curl "http://my-url.com?start_date=$start_date&end_date=$period_end_date"
  curl --output result-$start_date-$period_end_date.zip "https://portal.helloworks.com/workflow/transactions/detail/?mode=live&$worflows&start_date=$start_date&end_date=$period_end_date"

  # Update the start date for the next period
  start_date=$(date -d "$period_end_date + 1 second" "+%Y-%m-%dT%H:%M:%S.000Z")
done

# Extract all CSV files from the zip files
for f in *.zip; do unzip -B -j "$f" "*.csv"; done

# Merge all CSV files into one
csvstack Open*.csv* >all.csv