Check periodically for validity of Endaoment projects

[divine-comedian]

We should periodically (~1 month) check for updates on our import Endaoment projects. This should be able to be done by their API

We should check and update the following fields if there are new changes.

• title
• description

If the query returns a response indicating that it has been offboarded from Endaoment we should change the projects status to cancelled.

Endaoment just published new rest APIs that can let us fetch project information by ID
https://api.endaoment.org/oas#/EndaomentSdk/getOrgsById

projects ID

We'll need to use this list of ~3613 projects that need to be checked monthly for new description and title

org-with-ids.csv

in addition these projects should be added to the list of project data we check periodically

Ukraine America Initiative
https://app.endaoment.org/orgs/88-2280006
Project ID: 0ede481a-c59c-4201-8b0c-69e375cdd7ea
Category: Disaster Preparedness and Relief Services

Reef Guardians Hawaii
https://app.endaoment.org/orgs/47-3975420
Project ID: 2627e4ee-f713-4298-84d2-9fbad53d9ed9
category: Water Resource, Wetlands Conservation and Management

Mindfulness Through Play
https://app.endaoment.org/orgs/82-4211804
Project ID: 2d257c44-c39e-4f41-b4b4-24dd732f545d
Category: Student Services and Organizations

SOLUTIONS PROJECT INC
https://app.endaoment.org/orgs/46-3811348
Project ID: a60836a2-f06e-4b5b-9354-584a4ca5b4b0
Category: Energy Resources Conservation and Development

Peace Winds America
https://app.endaoment.org/orgs/26-3744952
Project ID: 25b2e4a9-20de-4564-be24-fc523a22d65c
Category: Disaster Preparedness and Relief Services

Love Justice International
https://app.endaoment.org/orgs/71-0982808
Project ID: c8101dbe-f308-425c-a0a5-39a98316c02f
Category: Victims' Services

Metagovernance Project Inc
https://app.endaoment.org/orgs/85-3442527
Project ID: d94cdffb-50cc-4127-806d-051b26f5ce00
Category: Computer Science

[divine-comedian]

@divine-comedian needs to find the id of the projects and add it to the CSV

[divine-comedian]

Still need to get project Ids along with mainnet address to properly map them together

[divine-comedian]

@HrithikSampson can take on this one with guidance from @mohammadranjbarz once it is unblocked by meee

[divine-comedian]

We'll need to use this list of ~3613 projects that need to be checked monthly for new description and title

org-with-ids.csv

in addition these projects should be added to the list of project data we check periodically

Ukraine America Initiative
https://app.endaoment.org/orgs/88-2280006
Project ID: 0ede481a-c59c-4201-8b0c-69e375cdd7ea
Category: Disaster Preparedness and Relief Services

Reef Guardians Hawaii
https://app.endaoment.org/orgs/47-3975420
Project ID: 2627e4ee-f713-4298-84d2-9fbad53d9ed9
category: Water Resource, Wetlands Conservation and Management

Mindfulness Through Play
https://app.endaoment.org/orgs/82-4211804
Project ID: 2d257c44-c39e-4f41-b4b4-24dd732f545d
Category: Student Services and Organizations

SOLUTIONS PROJECT INC
https://app.endaoment.org/orgs/46-3811348
Project ID: a60836a2-f06e-4b5b-9354-584a4ca5b4b0
Category: Energy Resources Conservation and Development

Peace Winds America
https://app.endaoment.org/orgs/26-3744952
Project ID: 25b2e4a9-20de-4564-be24-fc523a22d65c
Category: Disaster Preparedness and Relief Services

Love Justice International
https://app.endaoment.org/orgs/71-0982808
Project ID: c8101dbe-f308-425c-a0a5-39a98316c02f
Category: Victims' Services

Metagovernance Project Inc
https://app.endaoment.org/orgs/85-3442527
Project ID: d94cdffb-50cc-4127-806d-051b26f5ce00
Category: Computer Science

[divine-comedian]

@HrithikSampson this should be unblocked now - you have the project IDs to start creating the checker service

for testing purposes we should try to set a higher frequency - perhaps every 24 hours - being mindful of any impact on server resources.

Additionally once this issue passes QA we should change this cronjob to run every month to not affect resource consumption