Skip to content

Improve Foster Records Import #393

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
jwtruver opened this issue Jul 14, 2021 · 3 comments · Fixed by #517
Closed

Improve Foster Records Import #393

jwtruver opened this issue Jul 14, 2021 · 3 comments · Fixed by #517
Assignees
Labels
enhancement New feature or request Importing

Comments

@jwtruver
Copy link
Collaborator

A continuation of closed issue #354 (#354)

We do not have access into the Foster records. It was decided to remove the foster records from the UI for now.

Open an issue for importing foster records in "some way" ...the api is not able to export

@c-simpson c-simpson added enhancement New feature or request Importing labels Jul 15, 2021
@c-simpson
Copy link
Collaborator

c-simpson commented Jul 15, 2021

The SL API does not provide foster info in particular, but does provide an Animal Events endpoint. To gather foster events, we'd need to

  • Use the Animals feed to collect the IDs of all animals who have come though PAWS
  • Then use the Animal Events endpoint to get the Events associated with each animal
  • Filter the Events data to keep just the foster events
  • Populate a db table something like this
person_id animal_id date event
12345 987654321 2020-09-17 Foster.Out
12345 987654321 2020-10-16 Foster.Return

Then we could get the foster events for the 360 view by going from match_id -> shelterluv.person_id and returning all the events associated with the person.

This might be something @urirot could add into his SL people scheduled data pull.

@urirot
Copy link
Collaborator

urirot commented Jul 16, 2021

@c-simpson Looks like we are already gathering this data on each 360 request. don't think we have any records like foster or adoption in our permanent data set.

take a look here in the common_api endpoint. by what you're describing it looks like the foster data should already be available to us. @dcstlouis I know have already been looking into that. I wonder what was missing.
can one of you clarify?

@c-simpson
Copy link
Collaborator

@urirot My guess is that somebody expected it would be available in the SL API Person Details endpoint, but it only provides a list of adopted animals.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request Importing
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants