How to use the API Verification Tool to Verify Wicked is receiving your Data

This article will help you learn about the API verification tool and how to use it to verify we're receiving your data.

• • Display Filters
  • API Specific Filters
• Order Validation Checklist
• Contact Validation Checklist
• API Troubleshooting Questions

Introduction to API Verification Tool

The API Verification Tool is a Wicked Reports feature designed to help you verify that your data is passing into your account as expected. All API data, including HTTP posts and Zaps, will show up in this tool if your data is successfully received by Wicked Reports. 

The API Verification tool can be found in your Wicked account through the left navigation bar, under the API & Uploaders dropdown menu. Once you've accessed the tool, simply select the appropriate filters and ensure your data is passing accurately into Wicked Reports.

• If it is passing through correctly, then you're good to go!
• If it is not passing through correctly, then that likely means the data was not sent properly. Review our troubleshooting section, or send us a message at suppport@wickedreports.com.

Display Filters:

Use these filters to select the type of data you're sending to us, and for what date range.

• API DATA:
  • Contacts: All calls made to the /Contacts Endpoint when adding Contacts to Wicked Reports. 
  • Orders: All calls made to the /Orders Endpoint when adding Orders to Wicked Reports. 
  • OrderItems: All calls made to the /OrderItems Endpoint when adding Order Items to Wicked Reports
  • OrderPayments: All calls made to the /OrderPayments Endpoint when adding Order Payments to Wicked Reports. 
  • Products: All calls made to the /Products Endpoint when adding Products to Wicked Reports. 
  • Clicks: All calls made to the /Clicks Endpoint when adding Products to Wicked Reports.
  • Marketing: All calls made to the /Marketing Endpoint when adding Marketing data to Wicked Reports
• Date Range:
  • This will determine the timeline of your search.
• Live/Test Toggle:
  • Live ON: Will show all the live data being sent to Wicked Reports
  • Test ON: Will show all the test data being sent to Wicked Reports.

Order Validation Checklist:

This is a series of yes or no questions designed to help validate the quality of your API order data. This is not an exhaustive list, but will certainly prepare you with general coverage.    

1. Do you have all the required key-value pairs? And, do they have the correct format?
2. Are you using the correct conditional fields? (ContactID vs ContactEmail). ContactEmail is the recommended choice.
3. Have you reviewed the optional key-value pairs? And, do they have the correct format?
4. Verify your CreateDate:
   1. For your CreateDate value, are you certain you've converted it into a UTC+0 timezone?
      Note: If you're sending data via HTTP post or Zapier, this does not apply to you because Wicked does the conversion for you. However, all other data must be converted into UTC+0 before being passed into Wicked Reports.
   2. For your CreateDate value, are you certain you've formatted it correctly?
      (YYYY-MM-DD HH:MM:SS). Must be down to the second.
5. Verify that you are sending unique orders to Wicked on an immediate or daily basis:
   1. Are you certain you're sending a unique SourceID? (i.e. no duplicates SourceIDs)
   2. Are you certain you are sending data whose Date Added is no more than 1 day greater than the Create Date? (e.g. at a maximum, the Date Added is 01/02/2023 and Order Date is 01/01/2023)
   3. If you are sending IP Address, are you certain that you're using a unique IP Address per ContactEmail (or ContactID)?
6. If your business has subscriptions, then you must verify your SubscriptionID:
   1. If your business utilizes subscriptions, did you include the SubscriptionID key-value pair?
   2. If your business utilizes subscriptions, are you certain you're using a unique Subscription ID?
7. If you need to filter your reports by Product Information, then OrderItems and ProductData are required. Run Steps #1-5 to verify your OrderItems and ProductData.
8. If you need to process Payment Status (e.g. refunds), then OrderPayments is required. Run Steps #1-5 to verify your OrderPayments

If you've answered yes (or N/A) to all these questions, then you can feel confident that you've done your very best to validate the quality of your data. If you've answered no to any of these questions, then please rectify it and turn that no into a yes.

If you need further assistance in validating the quality of your data, then please reach out to us at support@wickedreports.com.

Contact Validation Checklist:

This is a series of yes or no questions designed to help validate the quality of your API order data. This is not an exhaustive list, but will certainly prepare you with general coverage.    

1. Have you added all the required key-value pairs? And, do they have the correct format?
2. Have you reviewed the optional key-value pairs? And, do they have the correct format?
3. Verify that you are sending unique orders to Wicked on an immediate or daily basis:
   1. Are you certain you're using a unique SourceID? (i.e. no duplicates SourceIDs)
   2. Are you certain you are sending data whose Date Added is no more than 1 day greater than the Create Date? (e.g. at a maximum, the Date Added is 01/02/2023 and Order Date is 01/01/2023)
4. Verify your CreateDate:
   1. For your CreateDate value, are you certain you've converted it into a UTC+0 timezone?
      Note: If you're sending data via HTTP post or Zapier, this does not apply because you'll simply be providing the timezone and we'll do the conversion. However, all other data must be converted into UTC+0 before being passed into Wicked Reports.
   2. For your CreateDate value, are you certain you've formatted it correctly?
      (YYYY-MM-DD HH:MM:SS). Must be down to the second.

If you've answered yes (or N/A) to all these questions, then you can feel confident that you've done your very best to validate the quality of your data. If you've answered no to any of these questions, then please rectify it and turn that no into a yes.

If you need further assistance in validating the quality of your data, then please reach out to us at support@wickedreports.com.

API Troubleshooting Questions:

Q: Have you confirmed that you have enabled the API?
Our recommendation is to turn on both the API integration and HTTP post-integration, for both contacts and orders. That'll ensure, in every case, your Inbound API is ready to receive your data. This can be done on the authorizations page in your Wicked account.

Q: Are you using the correct API Key, as provided by Wicked Reports?
Whenever you turn on your API integration on the authorizations page, you'll be provided with your account's unique API key. Please ensure this is the API key you're using.

Q: Are you using the correct headers?
Each API call should include an “apikey” custom header parameter. However, you may or may not want to include the "test" header, depending on whether or not you are trying to send test data.

Q: Are you sending test data?
Each API can include a "test" header. If this header is turned on, then you'll need to turn the Test toggle on so you can view the data. To send live data, you'll need to remove the "test" header.

Q: Are you using the correct Inbound API endpoints?
All our Inbound API endpoints are available in our API documentation. However, if you're sending data via HTTP Post, then you'll want to use the endpoints outlined in our HTTP Post articles.

Q: Are any required key-value pairs missing or incorrectly formatted?
All Inbound API Endpoints have some required and some optional key-value pairs. If you're missing any required keys, or have misformatted any of the values, then Wicked Reports will not successfully receive your data. Please ensure you have all the required keys and the values are formatted as per our technical documentation on API Endpoints