Discussions
Pulling Attraction Data and Associated Park Data
4 months ago by Jeffrey Brown
I have some questions regarding pulling data out of Corrigo using the API. Here is the content around what we are trying to pull. We are looking at pulling Attraction data and associated park from Corrigo. Looking at the API documentation there are several entities that I have pulled down and started looking at the data on how it connects.
Entities Pulled:
• Address2
• Location
• AssetTree
• WorkOrder
• Space
Questions:
- How do we determine if an attraction was added to a particular park within Corrigo? Which table and how would I filter my query to pull?
- Space Table Start Date?
- If an attraction was removed from a park how do we see that in Corrigo? Which table and how would I filter my query to pull?
- Looks like “IsRemoved” field on the space table but what MoveOutDate / EndDate?
- What would validate a change to an attraction? Which table and how would I filter my query to pull?
- I understand WO would indicate an Attraction is down or being repaired but would it indicate an Add or Removal?
- If so how?
- So on the space table I got the following return data and would like to know if and how this would answer my first three questions.
Thanks,
Jeffery Brown