SSIS Components for Shopify

Build 24.0.9060

ProductResourceFeedbacks

Returns the product resource feedback for the currently authenticated app.

Table-Specific Information

Select

The component uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The component processes other filters client-side within the component.

  • ProductId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM ProductResourceFeedbacks
  SELECT * FROM ProductResourceFeedbacks WHERE ProductId = 'Val1'

Insert

The following columns can be used to create a new record:

ProductId, FeedbackGeneratedAt, Messages, ProductUpdatedAt, State

Columns

Name Type ReadOnly References Description
ProductId [KEY] String True

Products.Id

The product associated with the resource feedback.

FeedbackGeneratedAt Datetime True

The time when the feedback was generated. Used to help determine whether incoming feedback is outdated compared to existing feedback.

Messages String True

The feedback messages presented to the merchant.

ProductUpdatedAt Datetime True

The timestamp of the product associated with the feedback.

State String True

Conveys the state of the feedback and whether it requires merchant action or not.

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