Streamline your workflow by using FEVO's API to pull data directly within your data warehouse. Here are some helpful tips and essential steps to get started.
How to Get Started
Connect with your FEVO Representative to capture your unique User ID(s) and Access Key(s) in order to connect
Important Tips & Troubleshooting
If your organization manages more than one team, each team has a unique User ID and Access Key. Please double check that this is correct.
Access Order API Definitions here.
You can run queries based on Order Date or Event Date
Order Adjustment Order # will match back to the Order #
Order Adjustment Request Types:
1 = Cancel
7 = Partial Refund
Order Adjustment Status Code
1 = Approved
This is the only status you should see come through
FAQs
What information do we receive via the API?
All fields in the FEVO Sales Report.
What if I see a 502 Server Error?
Please double check your User ID. If you manage more than one key, the User ID is different.
What is the Order Number?
The Order number is FEVO's Order Number.
Why do I see an Order Adjustment populate when running specific event dates?
The Order Adjustments will populate based on the event date.
How often is the data updated or refreshed?
Data is real-time. Future is delayed up to 1 hour.
Are records updated? If so, do they come in as new records or are the old ones overwritten?
Only if order adjustments are made. The order is updated or removed and an order adjustment is added.
Do records get deleted? If so, is there a retention policy we should be aware of?
Records are soft deleted. We do have a retention policy and retain transactional data up to six years.
Is there anything we should know about the data from the start such as unique identifiers, keys, additional business logic?
No