Codeunit 30176 Shpfy Product API
src/Apps/W1/Shopify/App/src/Products/Codeunits/ShpfyProductAPI.Codeunit.al749 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.Shopify;using Microsoft.Inventory.Item;using System.Environment;/// <summary>/// Codeunit Shpfy Product API (ID 30176)./// </summary>codeunit 30176 "Shpfy Product API"{ Access = Internal; Permissions = tabledata Item = r; var Shop: Record "Shpfy Shop"; CommunicationMgt: Codeunit "Shpfy Communication Mgt."; JsonHelper: Codeunit "Shpfy Json Helper"; ProductEvents: Codeunit "Shpfy Product Events"; VariantApi: Codeunit "Shpfy Variant API"; MetafieldAPI: Codeunit "Shpfy Metafield API"; /// <summary> /// Create Product. /// </summary> /// <param name="ShopifyProduct">Parameter of type Record "Shopify Product".</param> /// <param name="ShopifyVariant">Parameter of type Record "Shopify Variant".</param> internal procedure CreateProduct(var ShopifyProduct: Record "Shpfy Product"; var ShopifyVariant: Record "Shpfy Variant"; var ShopifyTag: Record "Shpfy Tag"): BigInteger var NewShopifyProduct: Record "Shpfy Product"; JResponse: JsonToken; Data: Text; GraphQuery: TextBuilder; begin ShopifyVariant.FindSet(); ProductEvents.OnBeforeSendCreateShopifyProduct(Shop, ShopifyProduct, ShopifyVariant, ShopifyTag); GraphQuery.Append('{"query":"mutation {productCreate(product: {'); GraphQuery.Append('title: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyProduct.Title)); GraphQuery.Append('\"'); Data := ShopifyProduct.GetDescriptionHtml(); if Data <> '' then begin GraphQuery.Append(', descriptionHtml: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(Data)); GraphQuery.Append('\"'); end; if ShopifyProduct."Product Type" <> '' then begin GraphQuery.Append(', productType: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyProduct."Product Type")); GraphQuery.Append('\"'); end; GraphQuery.Append(', status: '); GraphQuery.Append(ConvertToProductStatus(ShopifyProduct.Status)); Data := ShopifyTag.GetCommaSeparatedTags(ShopifyProduct.Id); if Data <> '' then begin GraphQuery.Append(', tags: \"'); GraphQuery.Append(Data); GraphQuery.Append('\"'); end; if ShopifyProduct.Vendor <> '' then begin GraphQuery.Append(', vendor: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyProduct.Vendor)); GraphQuery.Append('\"'); end; if ShopifyProduct."Has Variants" or (ShopifyVariant."UoM Option Id" > 0) then begin GraphQuery.Append(', productOptions: [{name: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyVariant."Option 1 Name")); GraphQuery.Append('\", values: [{name: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyVariant."Option 1 Value")); GraphQuery.Append('\"}]}'); if ShopifyVariant."Option 2 Name" <> '' then begin GraphQuery.Append(', {name: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyVariant."Option 2 Name")); GraphQuery.Append('\", values: [{name: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyVariant."Option 2 Value")); GraphQuery.Append('\"}]}'); end; if ShopifyVariant."Option 3 Name" <> '' then begin GraphQuery.Append(', {name: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyVariant."Option 3 Name")); GraphQuery.Append('\", values: [{name: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyVariant."Option 3 Value")); GraphQuery.Append('\"}]}'); end; GraphQuery.Append(']'); end; AddDefaultCollectionsToGraphQuery(ShopifyProduct, GraphQuery); GraphQuery.Append('}) '); GraphQuery.Append('{product {legacyResourceId, onlineStoreUrl, onlineStorePreviewUrl, createdAt, updatedAt, tags}, userErrors {field, message}}'); GraphQuery.Append('}"}'); JResponse := CommunicationMgt.ExecuteGraphQL(GraphQuery.ToText()); NewShopifyProduct := ShopifyProduct; NewShopifyProduct.Id := JsonHelper.GetValueAsBigInteger(JResponse, 'data.productCreate.product.legacyResourceId'); if NewShopifyProduct.Id = 0 then exit;#pragma warning disable AA0139 NewShopifyProduct."Preview URL" := JsonHelper.GetValueAsText(JResponse, 'data.productCreate.product.onlineStorePreviewUrl', MaxStrLen(NewShopifyProduct."Preview URL")); NewShopifyProduct.URL := JsonHelper.GetValueAsText(JResponse, 'data.productCreate.product.onlineStoreUrl', MaxStrLen(NewShopifyProduct.URL)); NewShopifyProduct.UpdateTags(JsonHelper.GetArrayAsText(JResponse, 'data.productCreate.product.tags'));#pragma warning restore AA0139 NewShopifyProduct."Created At" := JsonHelper.GetValueAsDateTime(JResponse, 'data.productCreate.product.createdAt'); NewShopifyProduct."Updated At" := JsonHelper.GetValueAsDateTime(JResponse, 'data.productCreate.product.updatedAt'); NewShopifyProduct.Insert(); VariantApi.AddProductVariants(ShopifyVariant, NewShopifyProduct.Id, "Shpfy Variant Create Strategy"::REMOVE_STANDALONE_VARIANT); PublishProduct(NewShopifyProduct); exit(NewShopifyProduct.Id); end; local procedure AddDefaultCollectionsToGraphQuery(ShopifyProduct: Record "Shpfy Product"; var GraphQuery: TextBuilder) var Item: Record Item; ProductCollection: Record "Shpfy Product Collection"; CollectionsBuilder: TextBuilder; ItemFilter: Text; begin ProductCollection.SetRange("Shop Code", ShopifyProduct."Shop Code"); ProductCollection.SetRange(Default, true); if not ProductCollection.FindSet() then exit; repeat ItemFilter := ProductCollection.GetItemFilter(); if ItemFilter <> '' then begin Item.Reset(); Item.SetView(ItemFilter); Item.SetRange(SystemId, ShopifyProduct."Item SystemId"); if Item.IsEmpty() then continue; end; if CollectionsBuilder.Length > 0 then CollectionsBuilder.Append(', '); CollectionsBuilder.Append('\"gid://shopify/Collection/'); CollectionsBuilder.Append(Format(ProductCollection.Id)); CollectionsBuilder.Append('\"'); until ProductCollection.Next() = 0; if CollectionsBuilder.Length = 0 then exit; GraphQuery.Append(', collectionsToJoin: ['); GraphQuery.Append(CollectionsBuilder.ToText()); GraphQuery.Append(']'); end; /// <summary> /// Create image upload URL. /// </summary> /// <param name="Url">Url to upload the image.</param> /// <param name="ResourceUrl">Url containing the image after upload.</param> /// <param name="TenantMedia">Tenant media record containing image</param> /// <returns>True if Image Upload Urls created succesfully.</returns> internal procedure CreateImageUploadUrl(var Url: Text; var ResourceUrl: Text; var TenantMedia: Record "Tenant Media"): Boolean var MimeType: Text; Filename: Text; JResponse: JsonToken; JArray: JsonArray; Parameters: Dictionary of [Text, Text]; begin Clear(Url); Clear(ResourceUrl); MimeType := TenantMedia."Mime Type"; Filename := 'BC_Upload.' + MimeType.Split('/').Get(MimeType.Split('/').Count()); Parameters.Add('Filename', Filename); Parameters.Add('MimeType', MimeType); Parameters.Add('Resource', 'IMAGE'); Parameters.Add('HttpMethod', 'PUT'); JResponse := CommunicationMgt.ExecuteGraphQL("Shpfy GraphQL Type"::Products_CreateUploadUrl, Parameters); JArray := JsonHelper.GetJsonArray(JResponse, 'data.stagedUploadsCreate.stagedTargets'); if JArray.Count() = 1 then if JArray.Get(0, JResponse) then begin Url := JsonHelper.GetValueAsText(JResponse, 'url'); ResourceUrl := JsonHelper.GetValueAsText(JResponse, 'resourceUrl'); exit((Url <> '') and (ResourceUrl <> '')); end; end; [TryFunction] local procedure UploadImage(TenantMedia: Record "Tenant Media"; Url: Text) var Client: HttpClient; Content: HttpContent; Headers: HttpHeaders; Response: HttpResponseMessage; InStream: InStream; begin Content.GetHeaders(Headers); if Headers.Contains('Content-Type') then Headers.Remove('Content-Type'); Headers.Add('Content-Type', TenantMedia."Mime Type"); TenantMedia.CalcFields(Content); if TenantMedia.Content.HasValue then begin TenantMedia.Content.CreateInStream(InStream); Content.WriteFrom(InStream); Client.Put(Url, Content, Response); end; end; local procedure SetProductImage(Product: Record "Shpfy Product"; ResourceUrl: Text): BigInteger var Parameters: Dictionary of [Text, Text]; JResponse: JsonToken; JArray: JsonArray; begin Parameters.Add('ProductId', Format(Product.Id)); Parameters.Add('ResourceUrl', ResourceUrl); JResponse := CommunicationMgt.ExecuteGraphQL("Shpfy GraphQL Type"::Products_AddProductImage, Parameters); JArray := JsonHelper.GetJsonArray(JResponse, 'data.productCreateMedia.media'); if JArray.Count = 1 then if JArray.Get(0, JResponse) then exit(CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JResponse, 'id'))); end; local procedure UpdateProductImage(ProductId: BigInteger; ImageId: BigInteger; ResourceUrl: Text): BigInteger var Parameters: Dictionary of [Text, Text]; begin Parameters.Add('ProductId', Format(ProductId)); Parameters.Add('ResourceUrl', ResourceUrl); Parameters.Add('ImageId', Format(ImageId)); CommunicationMgt.ExecuteGraphQL("Shpfy GraphQL Type"::Products_UpdateProductImage, Parameters); exit(ImageId); end; [TryFunction] internal procedure UpdateProductImage(Parameters: Dictionary of [Text, Text]) begin CommunicationMgt.ExecuteGraphQL("Shpfy GraphQL Type"::Products_UpdateProductImage, Parameters); end; /// <summary> /// Update Shopify Product Image. /// </summary> /// <param name="Product">Parameter of type Record "Shopify Product".</param> /// <param name="Item">Parameter of type Record Item.</param> /// <returns>Return value of type BigInteger.</returns> internal procedure UpdateShopifyProductImage(Product: Record "Shpfy Product"; Item: Record Item; var BulkOperationInput: TextBuilder; var ParametersList: List of [Dictionary of [Text, Text]]; RecordCount: Integer): BigInteger var TenantMedia: Record "Tenant Media"; begin if Item.Picture.Count() = 0 then exit; if not TenantMedia.Get(Item.Picture.Item(1)) then exit; exit(UpdateShopifyProductImage(Product.Id, Product."Image Id", TenantMedia, BulkOperationInput, ParametersList, RecordCount)); end; /// <summary> /// Update Shopify Product Image. /// </summary> /// <param name="ProductId">Parameter of type BigInteger.</param> /// <param name="ImageId">Parameter of type BigInteger.</param> /// <param name="TenantMedia">Parameter of type Record "Tenant Media".</param> /// <param name="BulkOperationInput">Parameter of type TextBuilder.</param> /// <param name="ParametersList">Parameter of type List of [Dictionary of [Text, Text]].</param> /// <param name="RecordCount">Parameter of type Integer.</param> /// <returns>Shopify ImageId</returns> internal procedure UpdateShopifyProductImage(ProductId: BigInteger; ImageId: BigInteger; TenantMedia: Record "Tenant Media"; var BulkOperationInput: TextBuilder; var ParametersList: List of [Dictionary of [Text, Text]]; RecordCount: Integer): BigInteger var BulkOperationMgt: Codeunit "Shpfy Bulk Operation Mgt."; BulkOperationType: Enum "Shpfy Bulk Operation Type"; IBulkOperation: Interface "Shpfy IBulk Operation"; Parameters: Dictionary of [Text, Text]; Url: Text; ResourceUrl: Text; begin if CreateImageUploadUrl(Url, ResourceUrl, TenantMedia) then if UploadImage(TenantMedia, Url) then if RecordCount <= BulkOperationMgt.GetBulkOperationThreshold() then exit(UpdateProductImage(ProductId, ImageId, ResourceUrl)) else begin IBulkOperation := BulkOperationType::UpdateProductImage; Parameters.Add('ProductId', Format(ProductId)); Parameters.Add('ResourceUrl', ResourceUrl); Parameters.Add('ImageId', Format(ImageId)); ParametersList.Add(Parameters); BulkOperationInput.AppendLine(StrSubstNo(IBulkOperation.GetInput(), Format(ImageId), ResourceUrl, Format(ProductId))); exit(ImageId); end; end; /// <summary> /// Create Shopify Product Image. /// </summary> /// <param name="Product">Parameter of type Record "Shopify Product".</param> /// <param name="Item">Parameter of type Record Item.</param> /// <returns>Return value of type BigInteger.</returns> internal procedure UploadShopifyImage(var TenantMedia: Record "Tenant Media"; var ResourceUrl: Text): Boolean var Url: Text; begin if CreateImageUploadUrl(Url, ResourceUrl, TenantMedia) then exit(UploadImage(TenantMedia, Url)); end; /// <summary> /// Create Shopify Product Image. /// </summary> /// <param name="Product">Shopify Product which image is created.</param> /// <param name="Item">Item from which image is taken.</param> /// <returns>Id of created image in Shopify.</returns> internal procedure CreateShopifyProductImage(Product: Record "Shpfy Product"; Item: Record Item): BigInteger var TenantMedia: Record "Tenant Media"; ResourceUrl: Text; begin if Item.Picture.Count = 0 then exit; if Product."Image Id" <> 0 then exit; if not TenantMedia.Get(Item.Picture.Item(1)) then exit; if UploadShopifyImage(TenantMedia, ResourceUrl) then exit(SetProductImage(Product, ResourceUrl)); end; /// <summary> /// Get Image Data. /// </summary> /// <param name="JImageNode">Parameter of type JsonToken.</param> /// <param name="ImageData">Parameter of type Dictionary of [BigInteger, Text].</param> local procedure GetImageData(JImageNode: JsonToken; var ImageData: Dictionary of [BigInteger, Text]) var Data: Dictionary of [BigInteger, Text]; begin Data.Add(CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JImageNode, 'node.id')), JsonHelper.GetValueAsText(JImageNode, 'node.image.url')); ImageData := Data; end; /// <summary> /// Retrieve Shopify Product. /// </summary> /// <param name="ShopifyProduct">Parameter of type Record "Shopify Product".</param> /// <returns>Return value of type Boolean.</returns> internal procedure RetrieveShopifyProduct(var ShopifyProduct: Record "Shpfy Product"): Boolean var Parameters: Dictionary of [Text, Text]; GraphQLType: Enum "Shpfy GraphQL Type"; JProduct: JsonObject; JResponse: JsonToken; begin Parameters.Add('ProductId', Format(ShopifyProduct.Id)); Parameters.add('MaxLengthDescription', Format(MaxStrLen(ShopifyProduct.Description))); JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType::Products_GetProductById, Parameters); if JsonHelper.GetJsonObject(JResponse, JProduct, 'data.product') then exit(UpdateShopifyProductFields(ShopifyProduct, JProduct)); end; /// <summary> /// Retrieve Shopify Product Ids. /// </summary> /// <param name="ProductIds">Parameter of type Dictionary of [BigInteger, DateTime].</param> internal procedure RetrieveShopifyProductIds(var ProductIds: Dictionary of [BigInteger, DateTime]; NumberOfRecords: Integer) var Math: Codeunit "Shpfy Math"; Id: BigInteger; LastSyncTime: DateTime; UpdatedAt: DateTime; Parameters: Dictionary of [Text, Text]; GraphQLType: Enum "Shpfy GraphQL Type"; JProducts: JsonArray; JNode: JsonObject; JItem: JsonToken; JResponse: JsonToken; Cursor: Text; begin Clear(ProductIds); GraphQLType := GraphQLType::Products_GetProductIds; LastSyncTime := Shop.GetLastSyncTime("Shpfy Synchronization Type"::Products); Parameters.Add('Time', Format(LastSyncTime, 0, 9)); repeat JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters); if JsonHelper.GetJsonArray(JResponse, JProducts, 'data.products.edges') then begin foreach JItem in JProducts do begin Cursor := JsonHelper.GetValueAsText(JItem.AsObject(), 'cursor'); if JsonHelper.GetJsonObject(JItem.AsObject(), JNode, 'node') then begin Id := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JNode, 'id')); UpdatedAt := JsonHelper.GetValueAsDateTime(JNode, 'updatedAt'); if not ProductIds.ContainsKey(Id) then ProductIds.Add(Id, UpdatedAt) else ProductIds.Set(Id, Math.Max(ProductIds.Get(Id), UpdatedAt)); end; if NumberOfRecords <> 0 then if ProductIds.Count >= NumberOfRecords then exit; end; GraphQLType := GraphQLType::Products_GetNextProductIds; if Parameters.ContainsKey('After') then Parameters.Set('After', Cursor) else Parameters.Add('After', Cursor); end; until not JsonHelper.GetValueAsBoolean(JResponse, 'data.products.pageInfo.hasNextPage'); end; /// <summary> /// Retrieve Shopify Product Images. /// </summary> /// <param name="ProductImages">Parameter of type Dictionary of [BigInteger, Dictionary of [BigInteger, Text]].</param> internal procedure RetrieveShopifyProductImages(var ProductImages: Dictionary of [BigInteger, Dictionary of [BigInteger, Text]]) var Id: BigInteger; ImageData: Dictionary of [BigInteger, Text]; Parameters: Dictionary of [Text, Text]; GraphQLType: Enum "Shpfy GraphQL Type"; JImages: JsonArray; JProducts: JsonArray; JNode: JsonObject; JImage: JsonToken; JItem: JsonToken; JResponse: JsonToken; Cursor: Text; MediaContentType: Text; begin Clear(ProductImages); GraphQLType := GraphQLType::Products_GetProductImages; repeat JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters); if JsonHelper.GetJsonArray(JResponse, JProducts, 'data.products.edges') then begin foreach JItem in JProducts do begin Cursor := JsonHelper.GetValueAsText(JItem.AsObject(), 'cursor'); if JsonHelper.GetJsonObject(JItem.AsObject(), JNode, 'node') then begin Id := JsonHelper.GetValueAsBigInteger(JNode, 'legacyResourceId'); if JsonHelper.GetJsonArray(JNode, JImages, 'media.edges') then if JImages.Count = 1 then begin JImages.Get(0, JImage); MediaContentType := JsonHelper.GetValueAsText(JImage, 'node.mediaContentType'); if MediaContentType = 'IMAGE' then begin GetImageData(JImage, ImageData); ProductImages.Add(Id, ImageData); end; end; end end; if Parameters.ContainsKey('After') then Parameters.Set('After', Cursor) else Parameters.Add('After', Cursor); end; GraphQLType := GraphQLType::Products_GetNextProductImages; until not JsonHelper.GetValueAsBoolean(JResponse, 'data.products.pageInfo.hasNextPage'); end; internal procedure CheckShopifyProductImageExists(ProductId: BigInteger; ImageId: BigInteger): Boolean var Parameters: Dictionary of [Text, Text]; GraphQLType: Enum "Shpfy GraphQL Type"; JMedias: JsonArray; JResponse: JsonToken; begin Parameters.Add('ProductId', Format(ProductId)); Parameters.add('ImageId', Format(ImageId)); JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType::Products_GetProductImage, Parameters); if JsonHelper.GetJsonArray(JResponse, JMedias, 'data.product.media.edges') then if JMedias.Count = 1 then exit(true); end; /// <summary> /// Set Shop. /// </summary> /// <param name="Code">Parameter of type Code[20].</param> internal procedure SetShop(Code: Code[20]) begin Clear(Shop); Shop.Get(Code); SetShop(Shop); end; /// <summary> /// Set Shop. /// </summary> /// <param name="ShopifyShop">Parameter of type Record "Shopify Shop".</param> internal procedure SetShop(ShopifyShop: Record "Shpfy Shop") begin Shop := ShopifyShop; VariantApi.SetShop(Shop); CommunicationMgt.SetShop(Shop); MetafieldAPI.SetShop(Shop); end; /// <summary> /// Update Product. /// </summary> /// <param name="ShopifyProduct">Parameter of type Record "Shopify Product".</param> /// <param name="xShopifyProduct">Parameter of type Record "Shopify Product".</param> internal procedure UpdateProduct(var ShopifyProduct: Record "Shpfy Product"; var xShopifyProduct: Record "Shpfy Product") var JResponse: JsonToken; Data: Text; GraphQuery: TextBuilder; begin ProductEvents.OnBeforeSendUpdateShopifyProduct(Shop, ShopifyProduct, xShopifyProduct); GraphQuery.Append('{"query":"mutation {productUpdate(product: {id: \"gid://shopify/Product/'); GraphQuery.Append(Format(ShopifyProduct.Id)); GraphQuery.Append('\"'); if ShopifyProduct.Title <> xShopifyProduct.Title then begin GraphQuery.Append(', title: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyProduct.Title)); GraphQuery.Append('\"'); end; Data := ShopifyProduct.GetDescriptionHtml(); if Data <> xShopifyProduct.GetDescriptionHtml() then begin GraphQuery.Append(', descriptionHtml: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(Data)); GraphQuery.Append('\"'); end; if ShopifyProduct."Product Type" <> xShopifyProduct."Product Type" then begin GraphQuery.Append(', productType: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyProduct."Product Type")); GraphQuery.Append('\"'); end; if ShopifyProduct.Status <> xShopifyProduct.Status then begin GraphQuery.Append(', status: '); GraphQuery.Append(ConvertToProductStatus(ShopifyProduct.Status)); end; Data := ShopifyProduct.GetCommaSeparatedTags(); if Data <> '' then begin GraphQuery.Append(', tags: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(Data)); GraphQuery.Append('\"'); end; if ShopifyProduct.Vendor <> xShopifyProduct.Vendor then begin GraphQuery.Append(', vendor: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyProduct.Vendor)); GraphQuery.Append('\"'); end; if (ShopifyProduct."SEO Title" <> xShopifyProduct."SEO Title") or (ShopifyProduct."SEO Description" <> xShopifyProduct."SEO Description") then begin GraphQuery.Append(', seo: {'); GraphQuery.Append('description: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyProduct."SEO Description")); GraphQuery.Append('\", '); GraphQuery.Append('title: \"'); GraphQuery.Append(CommunicationMgt.EscapeGraphQLData(ShopifyProduct."SEO Title")); GraphQuery.Append('\", '); GraphQuery.Remove(GraphQuery.Length - 1, 2); GraphQuery.Append('}') end; GraphQuery.Append('}) '); GraphQuery.Append('{product {id, onlineStoreUrl, onlineStorePreviewUrl, updatedAt}, userErrors {field, message}}'); GraphQuery.Append('}"}'); JResponse := CommunicationMgt.ExecuteGraphQL(GraphQuery.ToText());#pragma warning disable AA0139 ShopifyProduct."Preview URL" := JsonHelper.GetValueAsText(JResponse, 'data.productUpdate.product.onlineStorePreviewUrl', MaxStrLen(ShopifyProduct."Preview URL")); ShopifyProduct.URL := JsonHelper.GetValueAsText(JResponse, 'data.productUpdate.product.onlineStoreUrl', MaxStrLen(ShopifyProduct.URL));#pragma warning restore AA0139 ShopifyProduct."Updated At" := JsonHelper.GetValueAsDateTime(JResponse, 'data.productUpdate.product.updatedAt'); end; internal procedure UpdateProductStatus(ShopifyProduct: Record "Shpfy Product"; Status: Enum "Shpfy Product Status") var JResponse: JsonToken; GraphQuery: TextBuilder; begin GraphQuery.Append('{"query":"mutation {productUpdate(product: {id: \"gid://shopify/Product/'); GraphQuery.Append(Format(ShopifyProduct.Id)); GraphQuery.Append('\"'); if ShopifyProduct.Status <> Status then begin GraphQuery.Append(', status: '); GraphQuery.Append(ConvertToProductStatus(Status)); end; GraphQuery.Append('}) '); GraphQuery.Append('{product {id}, userErrors {field, message}}'); GraphQuery.Append('}"}'); JResponse := CommunicationMgt.ExecuteGraphQL(GraphQuery.ToText()); end; /// <summary> /// Update Shopify Product Fields. /// </summary> /// <param name="ShopifyProduct">Parameter of type record "Shopify Product".</param> /// <param name="JProduct">Parameter of type JsonObject.</param> /// <returns>Return variable "Result" of type Boolean.</returns> internal procedure UpdateShopifyProductFields(var ShopifyProduct: record "Shpfy Product"; JProduct: JsonObject) Result: Boolean var UpdatedAt: DateTime; JMetafields: JsonArray; begin UpdatedAt := JsonHelper.GetValueAsDateTime(JProduct, 'updatedAt'); if UpdatedAt < ShopifyProduct."Updated At" then exit(false); Result := true; ShopifyProduct."Updated At" := UpdatedAt; ShopifyProduct."Created At" := JsonHelper.GetValueAsDateTime(JProduct, 'createdAt'); ShopifyProduct."Has Variants" := not JsonHelper.GetValueAsBoolean(JProduct, 'hasOnlyDefaultVariant');#pragma warning disable AA0139 ShopifyProduct.Description := JsonHelper.GetValueAsText(JProduct, 'description', MaxStrLen(ShopifyProduct.Description));#pragma warning restore AA0139 ShopifyProduct.SetDescriptionHtml(JsonHelper.GetValueAsText(JProduct, 'descriptionHtml'));#pragma warning disable AA0139 ShopifyProduct."Preview URL" := JsonHelper.GetValueAsText(JProduct, 'onlineStorePreviewUrl', MaxStrLen(ShopifyProduct."Preview URL")); ShopifyProduct.URL := JsonHelper.GetValueAsText(JProduct, 'onlineStoreUrl', MaxStrLen(ShopifyProduct.URL)); ShopifyProduct."Product Type" := JsonHelper.GetValueAsText(JProduct, 'productType', MaxStrLen(ShopifyProduct."Product Type"));#pragma warning restore AA0139 ShopifyProduct.UpdateTags(JsonHelper.GetArrayAsText(JProduct, 'tags'));#pragma warning disable AA0139 ShopifyProduct.Title := JsonHelper.GetValueAsText(JProduct, 'title', MaxStrLen(ShopifyProduct.Title)); ShopifyProduct.Vendor := JsonHelper.GetValueAsText(JProduct, 'vendor', MaxStrLen(ShopifyProduct.Vendor)); ShopifyProduct."SEO Description" := JsonHelper.GetValueAsText(JProduct, 'seo.description', MaxStrLen(ShopifyProduct."SEO Description")); ShopifyProduct."SEO Title" := JsonHelper.GetValueAsText(JProduct, 'seo.title', MaxStrLen(ShopifyProduct."SEO Title"));#pragma warning restore AA0139 ShopifyProduct.Status := ConvertToProductStatus(JsonHelper.GetValueAsText(JProduct, 'status')); ShopifyProduct.Modify(false); if JsonHelper.GetJsonArray(JProduct, JMetafields, 'metafields.edges') then MetafieldAPI.UpdateMetafieldsFromShopify(JMetafields, Database::"Shpfy Product", ShopifyProduct.Id); end; local procedure ConvertToProductStatus(Value: Text): Enum "Shpfy Product Status" begin Value := CommunicationMgt.ConvertToCleanOptionValue(Value); if Enum::"Shpfy Product Status".Names().Contains(Value) then exit(Enum::"Shpfy Product Status".FromInteger(Enum::"Shpfy Product Status".Ordinals().Get(Enum::"Shpfy Product Status".Names().IndexOf(Value)))) else exit(Enum::"Shpfy Product Status"::Active); end; local procedure ConvertToProductStatus(Value: Enum "Shpfy Product Status"): Text begin exit(Value.Names.Get(Value.Ordinals.IndexOf(Value.AsInteger())).ToUpper()); end; /// <summary> /// Gets all the Product Options for a product. /// </summary> /// <param name="ShopifyProductId">Shopify product ID for which the options are to be retrieved.</param> /// <returns>Dictionary of option IDs and option names.</returns> internal procedure GetProductOptions(ShopifyProductId: BigInteger) Options: Dictionary of [text, Text] var Parameters: Dictionary of [Text, Text]; JResponse: JsonToken; JOptions: JsonArray; JOption: JsonToken; begin Parameters.Add('ProductId', Format(ShopifyProductId)); JResponse := CommunicationMgt.ExecuteGraphQL(Enum::"Shpfy GraphQL Type"::Products_GetProductOptions, Parameters); JsonHelper.GetJsonArray(JResponse, JOptions, 'data.product.options'); foreach JOption in JOptions do Options.Add(JsonHelper.GetValueAsText(JOption, 'id'), JsonHelper.GetValueAsText(JOption, 'name')); end; /// <summary> /// Publish product to selected Shopify Sales Channels /// </summary> /// <param name="ShopifyProduct">Shopify product to be published</param> internal procedure PublishProduct(ShopifyProduct: Record "Shpfy Product") var SalesChannel: Record "Shpfy Sales Channel"; GraphQuery: Text; JResponse: JsonToken; begin if not FilterSalesChannelsToPublishTo(SalesChannel, ShopifyProduct."Shop Code") then exit; GraphQuery := CreateProductPublishGraphQuery(ShopifyProduct, SalesChannel); JResponse := CommunicationMgt.ExecuteGraphQL(GraphQuery); end; local procedure FilterSalesChannelsToPublishTo(var SalesChannel: Record "Shpfy Sales Channel"; ShopCode: Code[20]): Boolean var SalesChannelAPI: Codeunit "Shpfy Sales Channel API"; begin SalesChannel.SetRange("Shop Code", ShopCode); if SalesChannel.IsEmpty() then SalesChannelAPI.RetrieveSalesChannelsFromShopify(ShopCode); SalesChannel.SetRange(SalesChannel."Use for publication", true); if SalesChannel.IsEmpty() then begin SalesChannel.SetRange("Use for publication"); SalesChannel.SetRange(SalesChannel.Default, true); if SalesChannel.IsEmpty() then exit(false); end; exit(true); end; local procedure CreateProductPublishGraphQuery(ShopifyProduct: Record "Shpfy Product"; var SalesChannel: Record "Shpfy Sales Channel"): Text var PublicationIds: TextBuilder; PublicationIdTok: Label '{ publicationId: \"gid://shopify/Publication/%1\"},', Locked = true; GraphQueryBuilder: TextBuilder; begin GraphQueryBuilder.Append('{"query":"mutation {publishablePublish(id: \"gid://shopify/Product/'); GraphQueryBuilder.Append(Format(ShopifyProduct.Id)); GraphQueryBuilder.Append('\" '); GraphQueryBuilder.Append('input: ['); SalesChannel.FindSet(); repeat PublicationIds.Append(StrSubstNo(PublicationIdTok, Format(SalesChannel.Id))); until SalesChannel.Next() = 0; GraphQueryBuilder.Append(PublicationIds.ToText().TrimEnd(',')); GraphQueryBuilder.Append('])'); GraphQueryBuilder.Append('{userErrors {field, message}}'); GraphQueryBuilder.Append('}"}'); exit(GraphQueryBuilder.ToText()); end; internal procedure UpdateProductOption(ProductId: BigInteger; OptionId: BigInteger; NewOptionName: Text) var Parameters: Dictionary of [Text, Text]; begin Parameters.Add('ProductId', Format(ProductId)); Parameters.Add('OptionId', Format(OptionId)); Parameters.Add('OptionName', NewOptionName); CommunicationMgt.ExecuteGraphQL("Shpfy GraphQL Type"::Products_UpdateProductOption, Parameters); end; /// <summary> /// Updates the product with a new image. /// </summary> /// <param name="ProductId">Updated product id</param> /// <param name="ResourceUrl">URL of the new image</param> internal procedure UpdateProductWithNewImage(ProductId: BigInteger; ResourceUrl: Text): BigInteger var Parameters: Dictionary of [Text, Text]; JMedias: JsonArray; JMedia: JsonToken; JResponse: JsonToken; begin Parameters.Add('ProductId', Format(ProductId)); Parameters.Add('ResourceUrl', ResourceUrl); JResponse := CommunicationMgt.ExecuteGraphQL("Shpfy GraphQL Type"::Products_UpdateProdWithImage, Parameters); if JsonHelper.GetJsonArray(JResponse, JMedias, 'data.productUpdate.product.media.nodes') then if JMedias.Count() = 1 then if JMedias.Get(0, JMedia) then exit(CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JMedia, 'id'))); end;}