Okendo & Stay AI beta integration updates - 2023.03.19
We're making updates to our Okendo & Stay AI beta integrations in preparation for making them generally available.
The notes below go table-by-table and detail which columns are being changed, added, or removed.
If you are currently using any of the columns that are changing or being removed in your custom code, you will need to roll out updates to reflect these changes, or you code may break.
The changes are being made to reflect our new internal column-naming conventions, which will help better reflect the API data structure in our extracted tables. Starting with these integrations, if a field being extracted is nested within another field in the API, the column naming convention will be to include the parent field and the nested field in the column name, separated by double underscores.
Please reach out to ben@daasity.com if you have any questions about this.
OKENDO
REVIEWS
Old column name | New column name(s) |
---|---|
ATTRIBUTES | REVIEWER__ATTRIBUTES |
AVATAR_URL | REVIEWER__AVATAR_URL |
DESCRIPTION | REWARD__DESCRIPTION |
INTEGRATION | REWARD__INTEGRATION |
IS_COUPON_UPGRADE | REWARD__IS_COUPON_UPGRADE |
LOCATION | REVIEWER__LOCATION__COUNTRY__CODE, REVIEWER__LOCATION__COUNTRY__NAME, REVIEWER__LOCATION__ZONE_CODE |
ORDER_ID | ORDER__ORDER_ID |
ORDER_NUMBER | ORDER__ORDER_NUMBER |
REPLY_BODY | REPLY__BODY |
REPLY_DATE_CREATED | REPLY__DATE_CREATED |
REPLY_IS_PRIVATE | REPLY__IS_PRIVATE |
REPLY_RAW_BODY | REPLY__RAW_BODY |
REVIEWER_DISPLAY_NAME | REVIEWER__DISPLAY_NAME |
REVIEWER_EMAIL | REVIEWER__EMAIL |
REVIEWER_IS_VERIFIED | REVIEWER__IS_VERIFIED |
REVIEWER_NAME | REVIEWER__NAME |
REVIEWER_VERIFIED_STATUS | REVIEWER__VERIFIED_STATUS |
SOCIAL_CONNECTION | REVIEWER__SOCIAL_CONNECTION |
TYPE | REWARD__TYPE |
VALUE | REWARD__VALUE |
N/A | REVIEWER__ATTRIBUTES |
REVIEW_MEDIA
No changes
REVIEW_ATTRIBUTES_WITH_RATING
Old column name | New column name |
---|---|
N/A | PRODUCT_ID |
N/A | SUBSCRIBER_ID |
N/A | VARIANT_ID |
REVIEW_PRODUCT_ATTRIBUTES
Old column name | New column name |
---|---|
N/A | PRODUCT_ID |
N/A | SUBSCRIBER_ID |
N/A | VARIANT_ID |
STAY_AI
ORDERS
Old Column Name | New Column Name |
---|---|
ADDRESS_ADDRESS1 | ADDRESS__ADDRESS1 |
ADDRESS_ADDRESS2 | ADDRESS__ADDRESS2 |
ADDRESS_CITY | ADDRESS__CITY |
ADDRESS_COMPANY | ADDRESS__COMPANY |
ADDRESS_COUNTRY | ADDRESS__COMPANY |
ADDRESS_COUNTRY_CODE | ADDRESS__COUNTRY_CODE |
ADDRESS_FIRST_NAME | ADDRESS__FIRST_NAME |
ADDRESS_LAST_NAME | ADDRESS__LAST_NAME |
ADDRESS_PHONE | ADDRESS__PHONE |
ADDRESS_PROVINCE | ADDRESS__PROVINCE |
ADDRESS_PROVINCE_CODE | ADDRESS__PROVINCE_CODE |
ADDRESS_ZIP | ADDRESS__ZIP |
ORDER_LINE_ITEMS
Old Column Name | New Column Name |
---|---|
ID | LINE_ID |
IS_ONE_TIME | N/A (This column was returning only NULL values) |
UNIT_PRICE | N/A (This column was returning only NULL values) |
N/A | CUSTOMER_ID |
N/A | SUBSCRIPTION_ID |
SUBSCRIPTIONS
Old Column Name | New Column Name |
---|---|
DELIVERY_ADDRESS_ADDRESS1 | DELIVERY_ADDRESS__ADDRESS1 |
DELIVERY_ADDRESS_ADDRESS2 | DELIVERY_ADDRESS__ADDRESS2 |
DELIVERY_ADDRESS_CITY | DELIVERY_ADDRESS__CITY |
DELIVERY_ADDRESS_COMPANY | DELIVERY_ADDRESS__COMPANY |
DELIVERY_ADDRESS_COUNTRY | DELIVERY_ADDRESS__COUNTRY |
DELIVERY_ADDRESS_COUNTRY_CODE | DELIVERY_ADDRESS__COUNTRY_CODE |
DELIVERY_ADDRESS_FIRST_NAME | DELIVERY_ADDRESS__FIRST_NAME |
DELIVERY_ADDRESS_LAST_NAME | DELIVERY_ADDRESS__LAST_NAME |
DELIVERY_ADDRESS_PHONE | DELIVERY_ADDRESS__PHONE |
DELIVERY_ADDRESS_PROVINCE | DELIVERY_ADDRESS__PROVINCE |
DELIVERY_ADDRESS_PROVINCE_CODE | DELIVERY_ADDRESS__PROVINCE_CODE |
DELIVERY_ADDRESS_ZIP | DELIVERY_ADDRESS__ZIP |
SUBSCRIPTION_LINE_ITEMS
Old Column Name | New Column Name |
---|---|
N/A | SKU |
N/A | CUSTOMER_ID |
Last updated