ODBC Driver for Shopify

Build 24.0.9062

ProductResourceFeedbacks

Returns a list of resource feedback objects..

Table-Specific Information

Select

The 本製品 processes all filters client-side within the 本製品. The following queries are the only ones processed server-side:
SELECT * FROM ProductResourceFeedbacks

SELECT * FROM ProductResourceFeedbacks WHERE ProductId = '123'

SELECT * FROM ProductResourceFeedbacks WHERE ProductId IN ('123', '235');

Insert

You must specify path and target to create a Redirect.

    INSERT INTO [ProductResourceFeedbacks] ([ProductId], [State], [Messages], [ResourceUpdatedAt], [FeedbackGeneratedAt]) VALUES (6578879004695, 'requires_action', 'My message.', '2023-05-05 09:00:00', '2023-05-05 09:00:00');

Columns

Name Type ReadOnly References Description
Id [KEY] Long False

Unique id of the resource.

ProductId Long False

Products.Id

Unique id of the resource.

Type String False

TType of resource for which feedback is returned. eg. Shop, Product.

State String False

Indicates the state that the Shop or resource is in, from the perspective of your app. Valid values are requires_action, or success.

Messages String False

The name of the report.

CreatedAt Datetime False

DateTime when the resource feedback record was stored by Shopify. Type: ISO 8601 UTC DateTime as string with year, month (or week), day, hour, minute, second, time zone.

UpdatedAt Datetime False

DateTime when the resource feedback record was last updated by Shopify. Type: ISO 8601 UTC DateTime as string with year, month (or week), day, hour, minute, second, time zone.

ResourceUpdatedAt Datetime False

The date and time (ISO 8601) when the report was last modified.

FeedbackGeneratedAt Datetime False

The time at which the payload is constructed. Used to help determine whether incoming feedback is outdated compared to feedback already received, and if it should be ignored upon arrival. Type: ISO 8601 UTC datetime as string with year, month [or week], day, hour, minute, second, millisecond, and time zone.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062