Power BI Connector for Shopify

Build 24.0.9060

CarrierServices

Returns a list of resource feedback objects..

Table-Specific Information

Select

The connector processes all filters client-side within the connector. The following queries are the only ones processed server-side:
SELECT * FROM CarrierServices

SELECT * FROM CarrierServices WHERE Id = '123'

SELECT * FROM CarrierServices WHERE Id IN ('123', '235');

Insert

You must specify path and target to create a Redirect.

INSERT INTO [CarrierServices] (Name, Type, CallbackUrl) VALUES ('ApiServiceType', 'api', 'https://test.com');

Update

You must specify the id to update a Redirect. For example:

UPDATE [CarrierServices] SET [Active] = 'false' WHERE [Id] = 59103608855;

Delete

You must specify the Id of the Redirect to delete it.

DELETE FROM [CarrierServices] WHERE [Id] = 59103608855;

Columns

Name Type ReadOnly References Description
Id [KEY] Long False

The ID of the carrier service.

Active Bool False

Whether this carrier service is active. If true, then the service will be available to serve rates in checkout.

Name String False

The name of the shipping service as seen by merchants and their customers.

CallbackUrl String False

The URL endpoint that Shopify needs to retrieve shipping rates. This must be a public URL.

Type String False

Distinguishes between API or legacy carrier services.

Format String False

The format of the data returned by the URL endpoint. json is the only valid value.

ServiceDiscovery String False

Whether merchants are able to send dummy data to your service through the Shopify admin to see shipping rate examples.

AdminGraphqlApiId String False

The GraphQL GID for this carrier service.

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