{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":806325399,"defaultBranch":"main","name":"salesforce-data-enrichment","ownerLogin":"ParkingReformNetwork","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2024-05-27T01:11:25.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/127456301?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1719686149.0","currentOid":""},"activityList":{"items":[{"before":"2f1d4725d42b31b50d4b4fdf90aa26e12ed16365","after":null,"ref":"refs/heads/EA/mailchimp","pushedAt":"2024-06-29T18:35:49.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"}},{"before":"f6913bb407a7b7a0b93051d9fc8547b63629a3dd","after":"564ab1e233bb87261ec8db22c2a4206eff0feee2","ref":"refs/heads/main","pushedAt":"2024-06-29T18:35:47.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Enrich data with Mailchimp (#14)","shortMessageHtmlLink":"Enrich data with Mailchimp (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2381907255\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/14\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/14/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/14\">#14</a>)"}},{"before":null,"after":"2f1d4725d42b31b50d4b4fdf90aa26e12ed16365","ref":"refs/heads/EA/mailchimp","pushedAt":"2024-06-29T18:33:17.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Salesforce stores lat and long as floats","shortMessageHtmlLink":"Salesforce stores lat and long as floats"}},{"before":"73fd192bfe23645d9d36e799e6805204518b1f2c","after":null,"ref":"refs/heads/EA/zip-fail","pushedAt":"2024-06-29T18:04:17.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"}},{"before":"7382c50f349a02293913d7efd5b0e421b886fa8c","after":"f6913bb407a7b7a0b93051d9fc8547b63629a3dd","ref":"refs/heads/main","pushedAt":"2024-06-29T18:04:16.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"US zipcode lookup may fail (#13)\n\nI think this happens with Guam, that the zipcode isn't in the database.","shortMessageHtmlLink":"US zipcode lookup may fail (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2381893867\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/13\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/13/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/13\">#13</a>)"}},{"before":null,"after":"73fd192bfe23645d9d36e799e6805204518b1f2c","ref":"refs/heads/EA/zip-fail","pushedAt":"2024-06-29T18:01:58.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"US zipcode lookup may fail","shortMessageHtmlLink":"US zipcode lookup may fail"}},{"before":"be2b7d6c73f8aff0d7733c0e46eb8dd19a05bd2c","after":null,"ref":"refs/heads/EA/eager-sf-writes","pushedAt":"2024-06-29T16:56:57.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"}},{"before":"e719b3a4218da9026c1baa6dfb019270479bac3b","after":"7382c50f349a02293913d7efd5b0e421b886fa8c","ref":"refs/heads/main","pushedAt":"2024-06-29T16:56:55.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Eagerly write updates to Salesforce (#12)\n\nI was about 800 records through updates when the program crashed because\r\nof an unrecognized state code. This is the second time a crash has\r\nhappened. The issue is that none of the prior changes are saved in this\r\ncase, so we have to rerun the entire program from the start.\r\n\r\nNow, the program eagerly writes updates when they are computed. Even if\r\nwe crash on record 1000, the first 999 will have been written.","shortMessageHtmlLink":"Eagerly write updates to Salesforce (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2381859659\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/12\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/12/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/12\">#12</a>)"}},{"before":null,"after":"be2b7d6c73f8aff0d7733c0e46eb8dd19a05bd2c","ref":"refs/heads/EA/eager-sf-writes","pushedAt":"2024-06-29T16:52:44.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Eagerly write updates to Salesforce","shortMessageHtmlLink":"Eagerly write updates to Salesforce"}},{"before":"f99783b2bcb5a4266559b0d4cac7324deaba6a8c","after":null,"ref":"refs/heads/EA/better-auth","pushedAt":"2024-06-29T14:57:58.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"}},{"before":"07a874b8336909d1e8b81858d91021ee56be3776","after":"e719b3a4218da9026c1baa6dfb019270479bac3b","ref":"refs/heads/main","pushedAt":"2024-06-29T14:57:57.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Use better authentication mechanism (#11)\n\nBefore, I was using a token from the Salesforce CLI, which expires very\r\nquickly. This method should instead work long term.","shortMessageHtmlLink":"Use better authentication mechanism (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2381793107\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/11\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/11/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/11\">#11</a>)"}},{"before":"9a916d8957f2fc2a9b7b88d3a10ee0e9e26d605f","after":"f99783b2bcb5a4266559b0d4cac7324deaba6a8c","ref":"refs/heads/EA/better-auth","pushedAt":"2024-06-29T14:56:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Update GHA too","shortMessageHtmlLink":"Update GHA too"}},{"before":null,"after":"9a916d8957f2fc2a9b7b88d3a10ee0e9e26d605f","ref":"refs/heads/EA/better-auth","pushedAt":"2024-06-29T14:53:44.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Use better authentication mechanism","shortMessageHtmlLink":"Use better authentication mechanism"}},{"before":"404b3fefe2a2ee28f4606d099feeaa96adc6555b","after":null,"ref":"refs/heads/EA/encryption-key","pushedAt":"2024-06-25T10:58:55.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"}},{"before":"442d9b602d377ac39b3603320c28651eb0e49efa","after":"07a874b8336909d1e8b81858d91021ee56be3776","ref":"refs/heads/main","pushedAt":"2024-06-25T10:58:55.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Add encryption key to env variables (#10)","shortMessageHtmlLink":"Add encryption key to env variables (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2372375937\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/10\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/10/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/10\">#10</a>)"}},{"before":null,"after":"404b3fefe2a2ee28f4606d099feeaa96adc6555b","ref":"refs/heads/EA/encryption-key","pushedAt":"2024-06-25T10:56:43.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Add encryption key to env variables","shortMessageHtmlLink":"Add encryption key to env variables"}},{"before":"72d76120ed7ece1c032122bf72836a249d54c913","after":null,"ref":"refs/heads/country-code","pushedAt":"2024-06-24T00:01:17.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"}},{"before":"76d769aed3318b6fdcff452bc34357ab78da3515","after":"442d9b602d377ac39b3603320c28651eb0e49efa","ref":"refs/heads/main","pushedAt":"2024-06-24T00:01:16.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Normalize country codes outside of US (#9)\n\nThis improves our reporting on how many international users we have.","shortMessageHtmlLink":"Normalize country codes outside of US (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2368949435\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/9\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/9/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/9\">#9</a>)"}},{"before":"828c5f0e8d0c628b9e6bbcaa4e205de854fa7c17","after":"72d76120ed7ece1c032122bf72836a249d54c913","ref":"refs/heads/country-code","pushedAt":"2024-06-23T23:58:36.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Normalize country codes outside of US","shortMessageHtmlLink":"Normalize country codes outside of US"}},{"before":null,"after":"828c5f0e8d0c628b9e6bbcaa4e205de854fa7c17","ref":"refs/heads/country-code","pushedAt":"2024-06-23T23:57:51.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Normalize country codes outside of US","shortMessageHtmlLink":"Normalize country codes outside of US"}},{"before":"ac46c353e7fed47a26a890ec2eb03ffdccf360ab","after":null,"ref":"refs/heads/cron-update","pushedAt":"2024-06-23T23:14:46.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"}},{"before":"43ea8bfbea9ef82f60159e053918a280d675d6d1","after":"76d769aed3318b6fdcff452bc34357ab78da3515","ref":"refs/heads/main","pushedAt":"2024-06-23T23:14:45.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Set up cron job (#8)\n\nThis uses my token, which was generated with `sf org display\r\n--target-org arellano@parkingreform.org`. TBD if this token will last\r\nlong enough or we need a longer-lived token.","shortMessageHtmlLink":"Set up cron job (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2368931553\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/8\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/8/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/8\">#8</a>)"}},{"before":null,"after":"ac46c353e7fed47a26a890ec2eb03ffdccf360ab","ref":"refs/heads/cron-update","pushedAt":"2024-06-23T23:09:40.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Set up cron job","shortMessageHtmlLink":"Set up cron job"}},{"before":"a55e12c64fbc313ccc817b282125e6b1ae6c3a61","after":null,"ref":"refs/heads/write-results","pushedAt":"2024-06-23T22:51:17.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"}},{"before":"0fe01af864f129feeebcfaa699bad5660715e6d7","after":"43ea8bfbea9ef82f60159e053918a280d675d6d1","ref":"refs/heads/main","pushedAt":"2024-06-23T22:51:16.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Write results to Salesforce (#7)\n\nWe don't write by default unless you specify `--write`.\r\n\r\nWe don't use the Bulk API because our # of expected records updates is\r\nlow and the Bulk API is more complex.","shortMessageHtmlLink":"Write results to Salesforce (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2368924240\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/7\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/7/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/7\">#7</a>)"}},{"before":null,"after":"a55e12c64fbc313ccc817b282125e6b1ae6c3a61","ref":"refs/heads/write-results","pushedAt":"2024-06-23T22:47:32.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Write results to Salesforce","shortMessageHtmlLink":"Write results to Salesforce"}},{"before":"bc84c5aa51296cf93b316432b6eb59416c2af386","after":null,"ref":"refs/heads/compute-changes","pushedAt":"2024-06-23T22:33:44.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"}},{"before":"7e55afddf218075278f8e3117eed440ccff927ef","after":"0fe01af864f129feeebcfaa699bad5660715e6d7","ref":"refs/heads/main","pushedAt":"2024-06-23T22:33:43.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Compute which entries have been changed (#5)\n\nThis allows us to update only the exact entries and fields that have\r\nbeen changed, which reduces risk and reduces API calls.\r\n\r\nThis PR also sets up logging.","shortMessageHtmlLink":"Compute which entries have been changed (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2368914637\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/5\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/5/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/5\">#5</a>)"}},{"before":null,"after":"ed4fc9b18857deaeb6e3855fbe96651a3a6bae70","ref":"refs/heads/gh-readonly-queue/main/pr-5-7e55afddf218075278f8e3117eed440ccff927ef","pushedAt":"2024-06-23T22:29:41.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"github-merge-queue[bot]","name":null,"path":"/apps/github-merge-queue","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9919?s=80&v=4"},"commit":{"message":"Compute which entries have been changed (#5)\n\nThis allows us to update only the exact entries and fields that have\nbeen changed, which reduces risk and reduces API calls.\n\nThis PR also sets up logging.","shortMessageHtmlLink":"Compute which entries have been changed (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2368914637\" data-permission-text=\"Title is private\" data-url=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/issues/5\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/ParkingReformNetwork/salesforce-data-enrichment/pull/5/hovercard\" href=\"https://github.com/ParkingReformNetwork/salesforce-data-enrichment/pull/5\">#5</a>)"}},{"before":"6ba6502d7f6f269f4230694371d77c80b71cb40d","after":"bc84c5aa51296cf93b316432b6eb59416c2af386","ref":"refs/heads/compute-changes","pushedAt":"2024-06-23T22:27:36.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Eric-Arellano","name":"Eric Arellano","path":"/Eric-Arellano","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/14852634?s=80&v=4"},"commit":{"message":"Compute which entries have been changed","shortMessageHtmlLink":"Compute which entries have been changed"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEcquYWwA","startCursor":null,"endCursor":null}},"title":"Activity · ParkingReformNetwork/salesforce-data-enrichment"}