Codeunit 30372 Shpfy Sales Channel API
src/Apps/W1/Shopify/App/src/Products/Codeunits/ShpfySalesChannelAPI.Codeunit.al104 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;/// <summary>/// Codeunit Shpfy Sales Channel API (ID 30372)./// </summary>codeunit 30372 "Shpfy Sales Channel API"{ Access = Internal; var JsonHelper: Codeunit "Shpfy Json Helper"; CommunicationMgt: Codeunit "Shpfy Communication Mgt."; /// <summary> /// Retrieves the sales channels from Shopify and updates the table with the new sales channels. /// </summary> /// <param name="ShopCode">The code of the shop.</param> internal procedure RetrieveSalesChannelsFromShopify(ShopCode: Code[20]) var GraphQLType: Enum "Shpfy GraphQL Type"; JResponse: JsonToken; JPublications: JsonArray; Cursor: Text; Parameters: Dictionary of [Text, Text]; CurrentChannels: List of [BigInteger]; begin CurrentChannels := CollectChannels(ShopCode); CommunicationMgt.SetShop(ShopCode); GraphQLType := GraphQLType::Base_GetSalesChannels; repeat JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters); if JsonHelper.GetJsonArray(JResponse, JPublications, 'data.publications.edges') then begin ExtractSalesChannels(JPublications, ShopCode, CurrentChannels, Cursor); if Parameters.ContainsKey('After') then Parameters.Set('After', Cursor) else Parameters.Add('After', Cursor); GraphQLType := GraphQLType::Base_GetNextSalesChannels; end; until not JsonHelper.GetValueAsBoolean(JResponse, 'data.publications.pageInfo.hasNextPage'); RemoveNotExistingChannels(CurrentChannels); end; local procedure CollectChannels(ShopCode: Code[20]): List of [BigInteger] var SalesChannel: Record "Shpfy Sales Channel"; Channels: List of [BigInteger]; begin SalesChannel.SetRange("Shop Code", ShopCode); if SalesChannel.FindSet() then repeat Channels.Add(SalesChannel.Id); until SalesChannel.Next() = 0; exit(Channels); end; local procedure RemoveNotExistingChannels(CurrentChannels: List of [BigInteger]) var SalesChannel: Record "Shpfy Sales Channel"; ChannelId: BigInteger; begin foreach ChannelId in CurrentChannels do begin SalesChannel.Get(ChannelId); SalesChannel.Delete(true); end; end; local procedure ExtractSalesChannels(JPublications: JsonArray; ShopCode: Code[20]; CurrentChannels: List of [BigInteger]; var Cursor: Text) var SalesChannel: Record "Shpfy Sales Channel"; JPublication: JsonToken; ChannelId: BigInteger; JCatalogEdges: JsonArray; JCatalogEdge: JsonToken; Handle: Text; begin foreach JPublication in JPublications do begin Cursor := JsonHelper.GetValueAsText(JPublication, 'cursor'); ChannelId := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JPublication, '$.node.id')); if not SalesChannel.Get(ChannelId) then begin SalesChannel.Init(); SalesChannel.Validate(Id, ChannelId); JCatalogEdges := JsonHelper.GetJsonArray(JPublication, '$.node.catalog.apps.edges'); JCatalogEdges.Get(0, JCatalogEdge); SalesChannel.Validate(Name, JsonHelper.GetValueAsText(JCatalogEdge, '$.node.title')); Handle := JsonHelper.GetValueAsText(JCatalogEdge, '$.node.handle'); if Handle = 'online_store' then SalesChannel.Default := true; SalesChannel."Shop Code" := ShopCode; SalesChannel.Insert(true); end else CurrentChannels.Remove(ChannelId); end; end;}