Codeunit 30161 Shpfy Import Order
src/Apps/W1/Shopify/App/src/Order handling/Codeunits/ShpfyImportOrder.Codeunit.al1,048 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.Finance.Currency;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Sales.Document;/// <summary>/// Codeunit Shpfy Import Order (ID 30161)./// </summary>codeunit 30161 "Shpfy Import Order"{ Access = Internal; Permissions = tabledata "Sales Line" = rim; TableNo = "Shpfy Orders to Import"; trigger OnRun() begin ImportOrderAndCreateOrUpdate(Rec."Shop Code", Rec.Id); end; internal procedure SetShop(ShopCode: Code[20]): Boolean begin if Shop.Code = ShopCode then exit(true); if not Shop.Get(ShopCode) then exit(false); CommunicationMgt.SetShop(Shop); exit(true); end; internal procedure ReimportExistingOrderConfirmIfConflicting(OrderHeader: Record "Shpfy Order Header") var ShopToRefresh: Record "Shpfy Shop"; OrderMapping: Codeunit "Shpfy Order Mapping"; begin OrderHeader.Get(OrderHeader."Shopify Order Id"); if ShopToRefresh.Get(OrderHeader."Shop Code") then begin ShopToRefresh.GetShopSettings();#pragma warning disable AA0214 ShopToRefresh.Modify();#pragma warning restore AA0214 end; ImportOrderAndCreateOrUpdate(OrderHeader."Shop Code", OrderHeader."Shopify Order Id"); OrderHeader.Get(OrderHeader."Shopify Order Id"); if OrderMapping.DoMapping(OrderHeader) then; end; internal procedure ImportCreateAndUpdateOrderHeaderFromMock(ShopCode: Code[20]; OrderId: BigInteger; MockJOrder: JsonObject) var OrderHeader: Record "Shpfy Order Header"; UpdatingOrderHeader: Boolean; begin UpdatingOrderHeader := EnsureOrderHeaderExists(OrderId, ShopCode, OrderHeader); if not SetOrderHeaderValuesFromJson(MockJOrder, UpdatingOrderHeader, OrderHeader) then exit; SetAndCreateRelatedRecords(MockJOrder, OrderHeader); OrderHeader.Modify(); end; internal procedure ImportCreateAndUpdateOrderLinesFromMock(OrderId: BigInteger; MockJOrderLines: JsonArray) var OrderLine: Record "Shpfy Order Line"; TempOrderLine: Record "Shpfy Order Line" temporary; DataCaptureDict: Dictionary of [BigInteger, JsonToken]; begin SetAndInsertOrderLines(OrderId, MockJOrderLines, TempOrderLine, DataCaptureDict); if not TempOrderLine.FindSet() then exit; repeat OrderLine.Copy(TempOrderLine); OrderLine.Insert(); until TempOrderLine.Next() = 0; end; var Shop: record "Shpfy Shop"; CommunicationMgt: Codeunit "Shpfy Communication Mgt."; JsonHelper: Codeunit "Shpfy Json Helper"; OrderEvents: Codeunit "Shpfy Order Events"; OrderFulfillments: Codeunit "Shpfy Order Fulfillments"; ProcessedConflictErr: Label 'The order has already been processed in Business Central, but an edition was received from Shopify. Changes were not propagated to the processed order in Business Central. Update the processed documents to match the received data from Shopify.'; DuplicateISOCodeTelemetryLbl: Label 'Multiple currencies found with ISO Code %1. Count: %2.', Comment = '%1 - ISO currency code from Shopify, %2 - number of currencies matching that ISO Code', Locked = true; CurrencyNotFoundTelemetryLbl: Label 'No currency found with ISO Code %1.', Comment = '%1 - ISO currency code from Shopify', Locked = true; CategoryTok: Label 'Shopify Integration', Locked = true; local procedure ImportOrderAndCreateOrUpdate(ShopCode: Code[20]; OrderId: BigInteger) var OrderHeader: Record "Shpfy Order Header"; TempOrderLine: Record "Shpfy Order Line" temporary; UpdatingOrderHeader: Boolean; JOrder: JsonObject; DataCaptureDict: Dictionary of [BigInteger, JsonToken]; ExchangeLineIds: List of [BigInteger]; Redundancy: Integer; begin if OrderId = 0 then exit; if not SetShop(ShopCode) then exit; UpdatingOrderHeader := EnsureOrderHeaderExists(OrderId, ShopCode, OrderHeader); if not RetrieveOrderHeaderJson(OrderId, OrderHeader.SystemId, JOrder) then exit; RetrieveAndSetOrderLines(OrderId, TempOrderLine, DataCaptureDict); ExchangeLineIds := GetExchangeItemLineIds(OrderHeader."Shopify Order Id", JOrder); if OrderHeader.IsProcessed() then if not OrderHeader."Has Order State Error" then if IsImportedOrderConflictingExistingOrder(JOrder, OrderHeader, TempOrderLine, ExchangeLineIds) then SetOrderAsConflicting(OrderHeader); if not SetOrderHeaderValuesFromJson(JOrder, UpdatingOrderHeader, OrderHeader) then exit; SetAndCreateRelatedRecords(JOrder, OrderHeader); OrderHeader.Modify(); OrderEvents.OnAfterImportShopifyOrderHeader(OrderHeader, not UpdatingOrderHeader); InsertOrderLinesAndRelatedRecords(TempOrderLine, DataCaptureDict, Redundancy, ExchangeLineIds); OrderHeader."Line Items Redundancy Code" := Redundancy; OrderHeader.Modify(); OrderFulfillments.GetFulfillments(Shop, OrderHeader."Shopify Order Id"); MarkExchangeItemOrderLines(OrderHeader, ExchangeLineIds); ConsiderRefundsInQuantityAndAmounts(OrderHeader); DeleteZeroQuantityLines(OrderHeader); if CheckToCloseOrder(OrderHeader) then CloseOrder(OrderHeader); if ShopifyInvoiceExists(OrderHeader) then MarkAsProcessed(OrderHeader); OrderEvents.OnAfterCreateShopifyOrderAndLines(OrderHeader, not UpdatingOrderHeader); end; local procedure ShopifyInvoiceExists(OrderHeader: Record "Shpfy Order Header"): Boolean var ShpfyInvoiceHeader: Record "Shpfy Invoice Header"; begin exit(ShpfyInvoiceHeader.Get(OrderHeader."Shopify Order Id")); end; local procedure MarkAsProcessed(OrderHeader: Record "Shpfy Order Header") begin OrderHeader.Validate(Processed, true); OrderHeader.Modify() end; local procedure InsertOrderLinesAndRelatedRecords(var TempOrderLine: Record "Shpfy Order Line" temporary; var DataCaptureDict: Dictionary of [BigInteger, JsonToken]; var Redundancy: Integer; ExchangeLineIds: List of [BigInteger]) var OrderLine: Record "Shpfy Order Line"; DataCapture: Record "Shpfy Data Capture"; OrderTaxLine: Record "Shpfy Order Tax Line"; Hash: Codeunit "Shpfy Hash"; JOrderLine: JsonToken; LineIds: Text; begin TempOrderLine.SetCurrentKey("Line Id"); TempOrderLine.SetAscending("Line Id", true); if not TempOrderLine.FindSet() then exit; repeat if not ExchangeLineIds.Contains(TempOrderLine."Line Id") then LineIds += '|' + Format(TempOrderLine."Line Id"); JOrderLine := DataCaptureDict.Get(TempOrderLine."Line Id"); if OrderLine.Get(TempOrderLine."Shopify Order Id", TempOrderLine."Line Id") then begin Clear(OrderLine); OrderLine.Copy(TempOrderLine); UpdateLocationIdAndDeliveryMethodOnOrderLine(OrderLine); OrderLine.Modify(); end else begin Clear(OrderLine); OrderLine.Copy(TempOrderLine); UpdateLocationIdAndDeliveryMethodOnOrderLine(OrderLine); OrderLine.Insert(); OrderTaxLine.ImportFromJson(OrderLine."Line Id", JsonHelper.GetJsonArray(JOrderLine, 'taxLines')); ImportCustomAttributtes(OrderLine."Shopify Order Id", OrderLine.SystemId, JsonHelper.GetJsonArray(JOrderLine, 'customAttributes')); end; DataCapture.Add(Database::"Shpfy Order Line", OrderLine.SystemId, Format(JOrderLine)); until TempOrderLine.Next() = 0; Redundancy := Hash.CalcHash(LineIds); end; local procedure EnsureOrderHeaderExists(OrderId: BigInteger; ShopCode: Code[20]; var OrderHeader: Record "Shpfy Order Header"): Boolean begin if OrderHeader.Get(OrderId) then exit(true); OrderHeader."Shopify Order Id" := OrderId; OrderHeader."Shop Code" := ShopCode; OrderHeader.Insert(); exit(false); end; local procedure DeleteZeroQuantityLines(OrderHeader: Record "Shpfy Order Header") var OrderLine: Record "Shpfy Order Line"; begin OrderLine.SetRange("Shopify Order Id", OrderHeader."Shopify Order Id"); OrderLine.SetRange(Quantity, 0); OrderLine.DeleteAll(); end; internal procedure ConsiderRefundsInQuantityAndAmounts(var OrderHeader: Record "Shpfy Order Header") var OrderLine: Record "Shpfy Order Line"; RefundLine: Record "Shpfy Refund Line"; IReturnRefundProcess: Interface "Shpfy IReturnRefund Process"; begin IReturnRefundProcess := Shop."Return and Refund Process"; if not IReturnRefundProcess.IsImportNeededFor("Shpfy Source Document Type"::Refund) then exit; OrderLine.SetRange("Shopify Order Id", OrderHeader."Shopify Order Id"); OrderLine.SetRange("Is Exchange Item", false); if not OrderLine.FindSet() then exit; repeat Clear(RefundLine); RefundLine.SetRange("Order Line Id", OrderLine."Line Id"); if not OrderHeader."Has Order State Error" then if OrderHeader."Cancelled At" <> 0DT then if RefundLine.IsEmpty() then if OrderHeader.IsProcessed() then SetOrderAsConflicting(OrderHeader); RefundLine.SetRange("Can Create Credit Memo", false); if not OrderHeader."Has Order State Error" then if not RefundLine.IsEmpty() then if OrderHeader.IsProcessed() then SetOrderAsConflicting(OrderHeader); RefundLine.CalcSums(Quantity, Amount, "Presentment Amount", "Subtotal Amount", "Presentment Subtotal Amount", "Total Tax Amount", "Presentment Total Tax Amount"); OrderLine."Discount Amount" -= (OrderLine."Unit Price" * RefundLine.Quantity) - RefundLine."Subtotal Amount"; OrderLine."Presentment Discount Amount" -= (OrderLine."Presentment Unit Price" * RefundLine.Quantity) - RefundLine."Presentment Subtotal Amount"; OrderLine.Quantity -= RefundLine.Quantity; OrderLine.Modify(); OrderHeader."Total Amount" -= RefundLine."Subtotal Amount" + RefundLine."Total Tax Amount"; OrderHeader."Subtotal Amount" -= RefundLine."Subtotal Amount"; OrderHeader."Presentment Total Amount" -= RefundLine."Presentment Subtotal Amount" + RefundLine."Presentment Total Tax Amount"; OrderHeader."Presentment Subtotal Amount" -= RefundLine."Presentment Subtotal Amount"; OrderHeader."VAT Amount" -= RefundLine."Total Tax Amount"; OrderHeader."Presentment VAT Amount" -= RefundLine."Presentment Total Tax Amount"; OrderEvents.OnAfterConsiderRefundsInQuantityAndAmounts(OrderHeader, OrderLine, RefundLine); until OrderLine.Next() = 0; OrderHeader.Modify(); end; internal procedure MarkExchangeItemOrderLines(var OrderHeader: Record "Shpfy Order Header"; ExchangeLineIds: List of [BigInteger]) var OrderLine: Record "Shpfy Order Line"; begin if ExchangeLineIds.Count() = 0 then exit; OrderLine.SetRange("Shopify Order Id", OrderHeader."Shopify Order Id"); OrderLine.SetLoadFields("Line Id", "Is Exchange Item"); if OrderLine.FindSet() then repeat if ExchangeLineIds.Contains(OrderLine."Line Id") and (not OrderLine."Is Exchange Item") then begin OrderLine."Is Exchange Item" := true; OrderLine.Modify(); end; until OrderLine.Next() = 0; end; local procedure GetExchangeItemLineIds(ShopifyOrderId: BigInteger; JOrder: JsonObject) ExchangeLineIds: List of [BigInteger] var IReturnRefundProcess: Interface "Shpfy IReturnRefund Process"; ReturnStatus: Enum "Shpfy Order Return Status"; ExchangeLineId: BigInteger; GraphQLType: Enum "Shpfy GraphQL Type"; Parameters: Dictionary of [Text, Text]; JResponse: JsonToken; JReturns: JsonArray; JReturn: JsonToken; JExchangeLineItems: JsonArray; JExchangeLineItem: JsonToken; JLineItems: JsonArray; JLineItem: JsonToken; begin IReturnRefundProcess := Shop."Return and Refund Process"; if not IReturnRefundProcess.IsImportNeededFor("Shpfy Source Document Type"::Refund) then exit; // Exchange line items only exist on orders that have a return. Skip the API call for the common case of no return. ReturnStatus := ConvertToOrderReturnStatus(JsonHelper.GetValueAsText(JOrder, 'returnStatus')); if ReturnStatus in [ReturnStatus::" ", ReturnStatus::"No Return"] then exit; Parameters.Add('OrderId', Format(ShopifyOrderId)); GraphQLType := "Shpfy GraphQL Type"::Orders_GetOrderExchangeLineItems; repeat JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters); GraphQLType := "Shpfy GraphQL Type"::Orders_GetNextOrderExchangeLineItems; JReturns := JsonHelper.GetJsonArray(JResponse, 'data.order.returns.nodes'); if Parameters.ContainsKey('After') then Parameters.Set('After', JsonHelper.GetValueAsText(JResponse, 'data.order.returns.pageInfo.endCursor')) else Parameters.Add('After', JsonHelper.GetValueAsText(JResponse, 'data.order.returns.pageInfo.endCursor')); foreach JReturn in JReturns do begin JExchangeLineItems := JsonHelper.GetJsonArray(JReturn, 'exchangeLineItems.nodes'); foreach JExchangeLineItem in JExchangeLineItems do begin JLineItems := JsonHelper.GetJsonArray(JExchangeLineItem, 'lineItems'); foreach JLineItem in JLineItems do begin ExchangeLineId := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JLineItem, 'id')); if (ExchangeLineId <> 0) and not ExchangeLineIds.Contains(ExchangeLineId) then ExchangeLineIds.Add(ExchangeLineId); end; end; end; until not JsonHelper.GetValueAsBoolean(JResponse, 'data.order.returns.pageInfo.hasNextPage'); end; internal procedure IsImportedOrderConflictingExistingOrder(JOrder: JsonObject; OrderHeader: Record "Shpfy Order Header"; var TempOrderLine: Record "Shpfy Order Line" temporary; ExchangeLineIds: List of [BigInteger]): Boolean var Hash: Codeunit "Shpfy Hash"; LineIds: Text; CurrentItemsQuantity: Decimal; ExchangeItemsQuantity: Decimal; Redundancy: Integer; begin TempOrderLine.SetCurrentKey("Line Id"); TempOrderLine.SetAscending("Line Id", true); if TempOrderLine.FindSet() then repeat if ExchangeLineIds.Contains(TempOrderLine."Line Id") then ExchangeItemsQuantity += TempOrderLine.Quantity else LineIds += '|' + Format(TempOrderLine."Line Id"); until TempOrderLine.Next() = 0; if OrderHeader."Current Total Items Quantity" <> 0 then begin CurrentItemsQuantity := JsonHelper.GetValueAsDecimal(JOrder, 'currentSubtotalLineItemsQuantity') - ExchangeItemsQuantity; if OrderHeader."Current Total Items Quantity" < CurrentItemsQuantity then exit(true); end; if OrderHeader."Line Items Redundancy Code" <> 0 then begin Redundancy := Hash.CalcHash(LineIds); if Redundancy <> OrderHeader."Line Items Redundancy Code" then exit(true); end; if OrderHeader."Shipping Charges Amount" <> JsonHelper.GetValueAsDecimal(JOrder, 'totalShippingPriceSet.shopMoney.amount') then exit(true); end; local procedure SetAndCreateRelatedRecords(JOrder: JsonObject; var OrderHeader: Record "Shpfy Order Header") var OrderTaxLine: Record "Shpfy Order Tax Line"; FulfillmentOrdersAPI: Codeunit "Shpfy Fulfillment Orders API"; ShippingCharges: Codeunit "Shpfy Shipping Charges"; Transactions: Codeunit "Shpfy Transactions"; ReturnsAPI: Codeunit "Shpfy Returns API"; RefundsAPI: Codeunit "Shpfy Refunds API"; IReturnRefundProcess: Interface "Shpfy IReturnRefund Process"; begin OrderTaxLine.ImportFromJson(OrderHeader."Shopify Order Id", JsonHelper.GetJsonArray(JOrder, 'taxLines')); OrderHeader.SetWorkDescription(JsonHelper.GetValueAsText(JOrder, 'note')); ImportCustomAttributtes(OrderHeader."Shopify Order Id", JsonHelper.GetJsonArray(JOrder, 'customAttributes')); OrderHeader.UpdateTags(JsonHelper.GetArrayAsText(JOrder, 'tags')); ImportRisks(OrderHeader, JsonHelper.GetJsonArray(JOrder, 'risk.assessments')); FulfillmentOrdersAPI.GetShopifyFulfillmentOrdersFromShopifyOrder(Shop, OrderHeader."Shopify Order Id"); ShippingCharges.UpdateShippingCostInfos(OrderHeader); Transactions.UpdateTransactionInfos(OrderHeader."Shopify Order Id"); IReturnRefundProcess := Shop."Return and Refund Process"; if IReturnRefundProcess.IsImportNeededFor("Shpfy Source Document Type"::Return) then ReturnsAPI.GetReturns(OrderHeader."Shopify Order Id", JsonHelper.GetJsonObject(JOrder, 'returns')); if IReturnRefundProcess.IsImportNeededFor("Shpfy Source Document Type"::Refund) then RefundsAPI.GetRefunds(JsonHelper.GetJsonArray(JOrder, 'refunds')); end; local procedure SetOrderAsConflicting(var OrderHeader: Record "Shpfy Order Header") begin OrderHeader."Has Order State Error" := true; OrderHeader."Has Error" := true; OrderHeader."Error Message" := CopyStr(ProcessedConflictErr, 1, MaxStrLen(OrderHeader."Error Message")); end; internal procedure MarkOrderConflictAsResolved(var OrderHeader: Record "Shpfy Order Header") begin OrderHeader."Has Order State Error" := false; OrderHeader."Has Error" := false; OrderHeader."Error Message" := ''; end; local procedure RetrieveOrderHeaderJson(OrderId: BigInteger; DataCaptureSystemId: Guid; var JOrder: JsonObject): Boolean var DataCapture: Record "Shpfy Data Capture"; OrderRetrieved: Boolean; begin OrderRetrieved := RetrieveOrderHeaderJson(OrderId, JOrder); if OrderRetrieved then DataCapture.Add(Database::"Shpfy Order Header", DataCaptureSystemId, Format(JOrder)); exit(OrderRetrieved); end; local procedure RetrieveOrderHeaderJson(OrderId: BigInteger; var JOrder: JsonObject): Boolean var Parameters: Dictionary of [Text, Text]; JResponse: JsonToken; begin Parameters.Add('OrderId', Format(OrderId)); if Shop."Advanced Shopify Plan" then Parameters.Add('StaffMember', 'staffMember { id }') else Parameters.Add('StaffMember', ''); JResponse := CommunicationMgt.ExecuteGraphQL("Shpfy GraphQL Type"::Orders_GetOrderHeader, Parameters); exit(JsonHelper.GetJsonObject(JResponse, JOrder, 'data.order')); end; local procedure RetrieveOrderLinesJson(OrderId: BigInteger; After: Text; var JOrderLines: JsonArray; var HasNextPage: Boolean; var EndCursor: Text): Boolean var Parameters: Dictionary of [Text, Text]; GraphQLType: Enum "Shpfy GraphQL Type"; JPageInfo: JsonObject; JResponse: JsonToken; begin Parameters.Add('OrderId', Format(OrderId)); GraphQLType := "Shpfy GraphQL Type"::Orders_GetOrderLines; if After <> '' then begin GraphQLType := "Shpfy GraphQL Type"::Orders_GetNextOrderLines; Parameters.Add('After', After); end; JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters); if JsonHelper.GetJsonObject(JResponse, JPageInfo, 'data.order.lineItems.pageInfo') then begin EndCursor := JsonHelper.GetValueAsText(JPageInfo, 'endCursor'); HasNextPage := JsonHelper.GetValueAsBoolean(JPageInfo, 'hasNextPage'); end; exit(JsonHelper.GetJsonArray(JResponse, JOrderLines, 'data.order.lineItems.nodes')); end; local procedure SetNewOrderHeaderValuesFromJson(JOrder: JsonObject; var OrderHeader: Record "Shpfy Order Header"): Boolean var OrderTransaction: Record "Shpfy Order Transaction"; OrderHeaderRecordRef: RecordRef; ICountyFromJson: Interface "Shpfy ICounty From Json"; OrderId: BigInteger; CompanyId: BigInteger; MainContactId: BigInteger; LocationId: BigInteger; RetailLocationId: BigInteger; CompanyName: Text; EMail: Text; FirstName: Text; LastName: Text; Phone: Text; StaffMemberId: BigInteger; JObject: JsonObject; begin OrderId := JsonHelper.GetValueAsBigInteger(JOrder, 'legacyResourceId'); if OrderId = 0 then exit(false); OrderHeader."Shopify Order Id" := OrderId; OrderHeader."Shop Code" := Shop.Code; OrderHeader."Use Shopify Order No." := Shop."Use Shopify Order No."; ICountyFromJson := Shop."County Source"; OrderHeaderRecordRef.GetTable(OrderHeader); JsonHelper.GetValueIntoField(JOrder, 'name', OrderHeaderRecordRef, OrderHeader.FieldNo("Shopify Order No.")); JsonHelper.GetValueIntoField(JOrder, 'createdAt', OrderHeaderRecordRef, OrderHeader.FieldNo("Created At")); JsonHelper.GetValueIntoField(JOrder, 'createdAt', OrderHeaderRecordRef, OrderHeader.FieldNo("Document Date")); EMail := JsonHelper.GetValueAsText(JOrder, 'email'); if EMail <> '' then OrderHeaderRecordRef.Field(OrderHeader.FieldNo(Email)).Value := CopyStr(EMail, 1, MaxStrLen(OrderHeader.Email)); JsonHelper.GetValueIntoField(JOrder, 'phone', OrderHeaderRecordRef, OrderHeader.FieldNo("Phone No.")); Phone := JsonHelper.GetValueAsText(JOrder, 'phone'); if Phone <> '' then OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Phone No.")).Value := CopyStr(Phone, 1, MaxStrLen(OrderHeader."Phone No.")); JsonHelper.GetValueIntoField(JOrder, 'customer.legacyResourceId', OrderHeaderRecordRef, OrderHeader.FieldNo("Customer Id")); JsonHelper.GetValueIntoField(JOrder, 'publication.name', OrderHeaderRecordRef, OrderHeader.FieldNo("Channel Name")); JsonHelper.GetValueIntoField(JOrder, 'app.name', OrderHeaderRecordRef, OrderHeader.FieldNo("App Name")); JsonHelper.GetValueIntoField(JOrder, 'currencyCode', OrderHeaderRecordRef, OrderHeader.FieldNo("Currency Code")); JsonHelper.GetValueIntoField(JOrder, 'presentmentCurrencyCode', OrderHeaderRecordRef, OrderHeader.FieldNo("Presentment Currency Code")); JsonHelper.GetValueIntoField(JOrder, 'test', OrderHeaderRecordRef, OrderHeader.FieldNo(Test)); JsonHelper.GetValueIntoField(JOrder, 'edited', OrderHeaderRecordRef, OrderHeader.FieldNo(Edited)); if Shop."Advanced Shopify Plan" then begin StaffMemberId := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JOrder, 'staffMember.id')); SetSalespersonOnOrderHeader(OrderHeader."Shop Code", StaffMemberId, OrderHeaderRecordRef); end; #region Sell-to Address info CompanyName := JsonHelper.GetValueAsText(JOrder, 'displayAddress.company'); FirstName := JsonHelper.GetValueAsText(JOrder, 'displayAddress.firstName'); LastName := JsonHelper.GetValueAsText(JOrder, 'displayAddress.lastName'); if FirstName = '' then FirstName := JsonHelper.GetValueAsText(JOrder, 'customer.firstName'); if LastName = '' then LastName := JsonHelper.GetValueAsText(JOrder, 'customer.lastName'); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Sell-to First Name")).Value := CopyStr(FirstName, 1, MaxStrLen(OrderHeader."Sell-to First Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Sell-to Last Name")).Value := CopyStr(LastName, 1, MaxStrLen(OrderHeader."Sell-to Last Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Sell-to Customer Name")).Value := CopyStr(GetName(FirstName, LastName, CompanyName), 1, MaxStrLen(OrderHeader."Sell-to Customer Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Sell-to Customer Name 2")).Value := CopyStr(GetName2(FirstName, LastName, CompanyName), 1, MaxStrLen(OrderHeader."Sell-to Customer Name 2")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Sell-to Contact Name")).Value := CopyStr(GetContactName(FirstName, LastName, CompanyName), 1, MaxStrLen(OrderHeader."Sell-to Contact Name")); JsonHelper.GetValueIntoField(JOrder, 'displayAddress.address1', OrderHeaderRecordRef, OrderHeader.FieldNo("Sell-to Address")); JsonHelper.GetValueIntoField(JOrder, 'displayAddress.address2', OrderHeaderRecordRef, OrderHeader.FieldNo("Sell-to Address 2")); JsonHelper.GetValueIntoField(JOrder, 'displayAddress.city', OrderHeaderRecordRef, OrderHeader.FieldNo("Sell-to City")); JsonHelper.GetValueIntoField(JOrder, 'displayAddress.countryCodeV2', OrderHeaderRecordRef, OrderHeader.FieldNo("Sell-to Country/Region Code")); JsonHelper.GetValueIntoField(JOrder, 'displayAddress.country', OrderHeaderRecordRef, OrderHeader.FieldNo("Sell-to Country/Region Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Sell-to County")).Value := ICountyFromJson.County(JsonHelper.GetJsonObject(JOrder, 'displayAddress')); JsonHelper.GetValueIntoField(JOrder, 'displayAddress.zip', OrderHeaderRecordRef, OrderHeader.FieldNo("Sell-to Post Code")); if EMail = '' then begin EMail := JsonHelper.GetValueAsText(JOrder, 'customer.defaultEmailAddress.emailAddress'); if EMail <> '' then OrderHeaderRecordRef.Field(OrderHeader.FieldNo(Email)).Value := CopyStr(EMail, 1, MaxStrLen(OrderHeader.Email)); end; if Phone = '' then begin Phone := JsonHelper.GetValueAsText(JOrder, 'displayAddress.phone'); if Phone = '' then Phone := JsonHelper.GetValueAsText(JOrder, 'customer.defaultPhoneNumber.phoneNumber'); if Phone = '' then Phone := JsonHelper.GetValueAsText(JOrder, 'customer.defaultAddress.phone'); if Phone <> '' then OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Phone No.")).Value := CopyStr(Phone, 1, MaxStrLen(OrderHeader."Phone No.")); end; #endregion #region Ship-to Address info CompanyName := JsonHelper.GetValueAsText(JOrder, 'shippingAddress.company'); FirstName := JsonHelper.GetValueAsText(JOrder, 'shippingAddress.firstName'); LastName := JsonHelper.GetValueAsText(JOrder, 'shippingAddress.lastName'); if FirstName = '' then FirstName := JsonHelper.GetValueAsText(JOrder, 'customer.firstName'); if LastName = '' then LastName := JsonHelper.GetValueAsText(JOrder, 'customer.lastName'); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Ship-to First Name")).Value := CopyStr(FirstName, 1, MaxStrLen(OrderHeader."Ship-to First Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Ship-to Last Name")).Value := CopyStr(LastName, 1, MaxStrLen(OrderHeader."Ship-to Last Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Ship-to Name")).Value := CopyStr(GetName(FirstName, LastName, CompanyName), 1, MaxStrLen(OrderHeader."Ship-to Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Ship-to Name 2")).Value := CopyStr(GetName2(FirstName, LastName, CompanyName), 1, MaxStrLen(OrderHeader."Ship-to Name 2")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Ship-to Contact Name")).Value := CopyStr(GetContactName(FirstName, LastName, CompanyName), 1, MaxStrLen(OrderHeader."Ship-to Contact Name")); JsonHelper.GetValueIntoField(JOrder, 'shippingAddress.address1', OrderHeaderRecordRef, OrderHeader.FieldNo("Ship-to Address")); JsonHelper.GetValueIntoField(JOrder, 'shippingAddress.address2', OrderHeaderRecordRef, OrderHeader.FieldNo("Ship-to Address 2")); JsonHelper.GetValueIntoField(JOrder, 'shippingAddress.city', OrderHeaderRecordRef, OrderHeader.FieldNo("Ship-to City")); JsonHelper.GetValueIntoField(JOrder, 'shippingAddress.countryCodeV2', OrderHeaderRecordRef, OrderHeader.FieldNo("Ship-to Country/Region Code")); JsonHelper.GetValueIntoField(JOrder, 'shippingAddress.country', OrderHeaderRecordRef, OrderHeader.FieldNo("Ship-to Country/Region Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Ship-to County")).Value := ICountyFromJson.County(JsonHelper.GetJsonObject(JOrder, 'shippingAddress')); JsonHelper.GetValueIntoField(JOrder, 'shippingAddress.zip', OrderHeaderRecordRef, OrderHeader.FieldNo("Ship-to Post Code")); JsonHelper.GetValueIntoField(JOrder, 'shippingAddress.latitude', OrderHeaderRecordRef, OrderHeader.FieldNo("Ship-to Latitude")); JsonHelper.GetValueIntoField(JOrder, 'shippingAddress.longitude', OrderHeaderRecordRef, OrderHeader.FieldNo("Ship-to Longitude")); if Phone = '' then begin Phone := JsonHelper.GetValueAsText(JOrder, 'shippingAddress.phone'); if Phone <> '' then OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Phone No.")).Value := CopyStr(Phone, 1, MaxStrLen(OrderHeader."Phone No.")); end; #endregion #region Bill-to Address info CompanyName := JsonHelper.GetValueAsText(JOrder, 'billingAddress.company'); FirstName := JsonHelper.GetValueAsText(JOrder, 'billingAddress.firstName'); LastName := JsonHelper.GetValueAsText(JOrder, 'billingAddress.lastName'); if FirstName = '' then FirstName := JsonHelper.GetValueAsText(JOrder, 'customer.firstName'); if LastName = '' then LastName := JsonHelper.GetValueAsText(JOrder, 'customer.lastName'); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Bill-to First Name")).Value := CopyStr(FirstName, 1, MaxStrLen(OrderHeader."Bill-to First Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Bill-to Lastname")).Value := CopyStr(LastName, 1, MaxStrLen(OrderHeader."Bill-to Lastname")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Bill-to Name")).Value := CopyStr(GetName(FirstName, LastName, CompanyName), 1, MaxStrLen(OrderHeader."Bill-to Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Bill-to Name 2")).Value := CopyStr(GetName2(FirstName, LastName, CompanyName), 1, MaxStrLen(OrderHeader."Bill-to Name 2")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Bill-to Contact Name")).Value := CopyStr(GetContactName(FirstName, LastName, CompanyName), 1, MaxStrLen(OrderHeader."Bill-to Contact Name")); JsonHelper.GetValueIntoField(JOrder, 'billingAddress.address1', OrderHeaderRecordRef, OrderHeader.FieldNo("Bill-to Address")); JsonHelper.GetValueIntoField(JOrder, 'billingAddress.address2', OrderHeaderRecordRef, OrderHeader.FieldNo("Bill-to Address 2")); JsonHelper.GetValueIntoField(JOrder, 'billingAddress.city', OrderHeaderRecordRef, OrderHeader.FieldNo("Bill-to City")); JsonHelper.GetValueIntoField(JOrder, 'billingAddress.countryCodeV2', OrderHeaderRecordRef, OrderHeader.FieldNo("Bill-to Country/Region Code")); JsonHelper.GetValueIntoField(JOrder, 'billingAddress.country', OrderHeaderRecordRef, OrderHeader.FieldNo("Bill-to Country/Region Name")); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Bill-to County")).Value := ICountyFromJson.County(JsonHelper.GetJsonObject(JOrder, 'billingAddress')); JsonHelper.GetValueIntoField(JOrder, 'billingAddress.zip', OrderHeaderRecordRef, OrderHeader.FieldNo("Bill-to Post Code")); if Phone = '' then begin Phone := JsonHelper.GetValueAsText(JOrder, 'billingAddress.phone'); if Phone <> '' then OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Phone No.")).Value := CopyStr(Phone, 1, MaxStrLen(OrderHeader."Phone No.")); end; #endregion #region B2B if JsonHelper.GetJsonObject(JOrder, JObject, 'purchasingEntity') then begin if JsonHelper.GetJsonObject(JOrder, JObject, 'purchasingEntity.company') then begin CompanyId := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JOrder, 'purchasingEntity.company.id')); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Company Id")).Value := CompanyId; MainContactId := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JOrder, 'purchasingEntity.company.mainContact.id')); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Company Main Contact Id")).Value := MainContactId; JsonHelper.GetValueIntoField(JOrder, 'purchasingEntity.company.mainContact.customer.legacyResourceId', OrderHeaderRecordRef, OrderHeader.FieldNo("Company Main Contact Cust. Id")); JsonHelper.GetValueIntoField(JOrder, 'purchasingEntity.company.mainContact.customer.defaultEmailAddress.emailAddress', OrderHeaderRecordRef, OrderHeader.FieldNo("Company Main Contact Email")); JsonHelper.GetValueIntoField(JOrder, 'purchasingEntity.company.mainContact.customer.defaultPhoneNumber.phoneNumber', OrderHeaderRecordRef, OrderHeader.FieldNo("Company Main Contact Phone No.")); if Format(OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Sell-to Customer Name")).Value) = '' then JsonHelper.GetValueIntoField(JOrder, 'purchasingEntity.company.name', OrderHeaderRecordRef, OrderHeader.FieldNo("Sell-to Customer Name")); end; if JsonHelper.GetJsonObject(JOrder, JObject, 'purchasingEntity.location') then begin LocationId := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JOrder, 'purchasingEntity.location.id')); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Company Location Id")).Value := LocationId; end; end; #endregion #region Retail Location if JsonHelper.GetJsonObject(JOrder, JObject, 'retailLocation') then begin RetailLocationId := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JOrder, 'retailLocation.legacyResourceId')); OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Retail Location Id")).Value := RetailLocationId; JsonHelper.GetValueIntoField(JOrder, 'retailLocation.name', OrderHeaderRecordRef, OrderHeader.FieldNo("Retail Location Name")); end; #endregion OrderHeaderRecordRef.SetTable(OrderHeader); OrderHeader."Currency Code" := TranslateCurrencyCode(OrderHeader."Currency Code"); OrderHeader."Presentment Currency Code" := TranslateCurrencyCode(OrderHeader."Presentment Currency Code"); OrderTransaction.SetRange("Shopify Order Id", OrderId); OrderTransaction.SetFilter(Status, '%1|%2', "Shpfy Transaction Status"::Pending, "Shpfy Transaction Status"::Success); OrderTransaction.SetFilter(Type, '%1|%2', "Shpfy Transaction Type"::Sale, "Shpfy Transaction Type"::Capture); OrderTransaction.SetCurrentKey(Amount, "Shopify Order Id", Status, Type); OrderTransaction.SetAscending(Amount, false); if OrderTransaction.FindFirst() then OrderHeader.Gateway := OrderTransaction.Gateway; exit(true); end; local procedure SetEditableOrderHeaderValuesFromJson(JOrder: JsonObject; var OrderHeader: Record "Shpfy Order Header") var OrderHeaderRecordRef: RecordRef; JObject: JsonObject; begin OrderHeaderRecordRef.GetTable(OrderHeader); JsonHelper.GetValueIntoField(JOrder, 'confirmed', OrderHeaderRecordRef, OrderHeader.FieldNo(Confirmed)); JsonHelper.GetValueIntoField(JOrder, 'updatedAt', OrderHeaderRecordRef, OrderHeader.FieldNo("Updated At")); JsonHelper.GetValueIntoField(JOrder, 'cancelledAt', OrderHeaderRecordRef, OrderHeader.FieldNo("Cancelled At")); JsonHelper.GetValueIntoField(JOrder, 'closed', OrderHeaderRecordRef, OrderHeader.FieldNo(Closed)); JsonHelper.GetValueIntoField(JOrder, 'closedAt', OrderHeaderRecordRef, OrderHeader.FieldNo("Closed At")); JsonHelper.GetValueIntoField(JOrder, 'processedAt', OrderHeaderRecordRef, OrderHeader.FieldNo("Processed At")); JsonHelper.GetValueIntoField(JOrder, 'unpaid', OrderHeaderRecordRef, OrderHeader.FieldNo(Unpaid)); JsonHelper.GetValueIntoField(JOrder, 'fullyPaid', OrderHeaderRecordRef, OrderHeader.FieldNo("Fully Paid")); JsonHelper.GetValueIntoField(JOrder, 'discountCode', OrderHeaderRecordRef, OrderHeader.FieldNo("Discount Code")); JsonHelper.GetValueIntoField(JOrder, 'discountCodes', OrderHeaderRecordRef, OrderHeader.FieldNo("Discount Codes")); JsonHelper.GetValueIntoField(JOrder, 'totalWeight', OrderHeaderRecordRef, OrderHeader.FieldNo("Total Weight")); JsonHelper.GetValueIntoField(JOrder, 'refundable', OrderHeaderRecordRef, OrderHeader.FieldNo(Refundable)); JsonHelper.GetValueIntoField(JOrder, 'taxesIncluded', OrderHeaderRecordRef, OrderHeader.FieldNo("VAT Included")); JsonHelper.GetValueIntoField(JOrder, 'taxExempt', OrderHeaderRecordRef, OrderHeader.FieldNo("Tax Exempt")); JsonHelper.GetValueIntoField(JOrder, 'totalPriceSet.shopMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Total Amount")); JsonHelper.GetValueIntoField(JOrder, 'totalPriceSet.presentmentMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Presentment Total Amount")); JsonHelper.GetValueIntoField(JOrder, 'subtotalPriceSet.shopMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Subtotal Amount")); JsonHelper.GetValueIntoField(JOrder, 'subtotalPriceSet.presentmentMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Presentment Subtotal Amount")); JsonHelper.GetValueIntoField(JOrder, 'totalTipReceivedSet.shopMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Total Tip Received")); JsonHelper.GetValueIntoField(JOrder, 'totalTipReceivedSet.presentmentMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Presentment Total Tip Received")); JsonHelper.GetValueIntoField(JOrder, 'totalTaxSet.shopMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("VAT Amount")); JsonHelper.GetValueIntoField(JOrder, 'totalTaxSet.presentmentMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Presentment VAT Amount")); JsonHelper.GetValueIntoField(JOrder, 'currentTotalDiscountsSet.shopMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Discount Amount")); JsonHelper.GetValueIntoField(JOrder, 'currentTotalDiscountsSet.presentmentMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Presentment Discount Amount")); JsonHelper.GetValueIntoField(JOrder, 'totalShippingPriceSet.shopMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Shipping Charges Amount")); JsonHelper.GetValueIntoField(JOrder, 'totalShippingPriceSet.presentmentMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Pres. Shipping Charges Amount")); JsonHelper.GetValueIntoField(JOrder, 'currentTotalPriceSet.shopMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Current Total Amount")); JsonHelper.GetValueIntoField(JOrder, 'currentSubtotalLineItemsQuantity', OrderHeaderRecordRef, OrderHeader.FieldNo("Current Total Items Quantity")); JsonHelper.GetValueIntoField(JOrder, 'totalCashRoundingAdjustment.paymentSet.presentmentMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Pres. Payment Rounding Amount")); JsonHelper.GetValueIntoField(JOrder, 'totalCashRoundingAdjustment.paymentSet.shopMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Payment Rounding Amount")); JsonHelper.GetValueIntoField(JOrder, 'totalCashRoundingAdjustment.refundSet.presentmentMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Pres. Refund Rounding Amount")); JsonHelper.GetValueIntoField(JOrder, 'totalCashRoundingAdjustment.refundSet.shopMoney.amount', OrderHeaderRecordRef, OrderHeader.FieldNo("Refund Rounding Amount")); JsonHelper.GetValueIntoField(Jorder, 'poNumber', OrderHeaderRecordRef, OrderHeader.FieldNo("PO Number")); JsonHelper.GetValueIntoField(JOrder, 'paymentTerms.paymentTermsType', OrderHeaderRecordRef, OrderHeader.FieldNo("Payment Terms Type")); JsonHelper.GetValueIntoField(JOrder, 'paymentTerms.paymentTermsName', OrderHeaderRecordRef, OrderHeader.FieldNo("Payment Terms Name")); OrderHeaderRecordRef.SetTable(OrderHeader); if JsonHelper.GetJsonObject(JOrder, JObject, 'purchasingEntity') then if JsonHelper.GetJsonObject(JOrder, JObject, 'purchasingEntity.company') then OrderHeader.B2B := true else OrderHeader.B2B := false else OrderHeader.B2B := false; if JsonHelper.GetJsonObject(JOrder, JObject, 'paymentTerms') then if JsonHelper.GetJsonObject(JOrder, JObject, 'paymentTerms.paymentSchedules') then OrderHeader."Due Date" := GetOrderDueDate(JsonHelper.GetJsonArray(JOrder, 'paymentTerms.paymentSchedules.nodes')); OrderHeader."Cancel Reason" := ConvertToCancelReason(JsonHelper.GetValueAsText(JOrder, 'cancelReason')); OrderHeader."Financial Status" := ConvertToFinancialStatus(JsonHelper.GetValueAsText(JOrder, 'displayFinancialStatus')); OrderHeader."Fulfillment Status" := ConvertToFulfillmentStatus(JsonHelper.GetValueAsText(JOrder, 'displayFulfillmentStatus')); OrderHeader."Return Status" := ConvertToOrderReturnStatus(JsonHelper.GetValueAsText(JOrder, 'returnStatus')); end; local procedure SetOrderHeaderValuesFromJson(JOrder: JsonObject; SetOnlyEditableFields: Boolean; var OrderHeader: Record "Shpfy Order Header"): Boolean begin if not SetOnlyEditableFields then if not SetNewOrderHeaderValuesFromJson(JOrder, OrderHeader) then exit(false); SetEditableOrderHeaderValuesFromJson(JOrder, OrderHeader); exit(true); end; local procedure SetOrderLineValuesFromJson(JOrderLine: JsonToken; OrderId: BigInteger; var OrderLine: Record "Shpfy Order Line"): Boolean var LocalOrderLine: Record "Shpfy Order Line"; OrderLineRecordRef: RecordRef; LineId: BigInteger; begin LineId := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JOrderLine, 'id')); OrderLine."Shopify Order Id" := OrderId; OrderLine."Line Id" := LineId; if LocalOrderLine.Get(OrderId, LineId) then OrderLine.Copy(LocalOrderLine); OrderLineRecordRef.GetTable(OrderLine); if (JsonHelper.GetValueAsText(JOrderLine, 'name') = 'Tip') and JsonHelper.IsNull(JOrderLine, 'product') then OrderLineRecordRef.Field(OrderLine.FieldNo(Tip)).Value := true; JsonHelper.GetValueIntoField(JOrderLine, 'product.legacyResourceId', OrderLineRecordRef, OrderLine.FieldNo("Shopify Product Id")); JsonHelper.GetValueIntoField(JOrderLine, 'title', OrderLineRecordRef, OrderLine.FieldNo(Description)); JsonHelper.GetValueIntoField(JOrderLine, 'quantity', OrderLineRecordRef, OrderLine.FieldNo(Quantity)); JsonHelper.GetValueIntoField(JOrderLine, 'variant.legacyResourceId', OrderLineRecordRef, OrderLine.FieldNo("Shopify Variant Id")); JsonHelper.GetValueIntoField(JOrderLine, 'variantTitle', OrderLineRecordRef, OrderLine.FieldNo("Variant Description")); JsonHelper.GetValueIntoField(JOrderLine, 'fulfillmentService.location.legacyResourceId', OrderLineRecordRef, OrderLine.FieldNo("Location Id")); JsonHelper.GetValueIntoField(JOrderLine, 'fulfillableQuantity', OrderLineRecordRef, OrderLine.FieldNo("Fulfillable Quantity")); JsonHelper.GetValueIntoField(JOrderLine, 'fulfillmentService.serviceName', OrderLineRecordRef, OrderLine.FieldNo("Fulfillment Service")); JsonHelper.GetValueIntoField(JOrderLine, 'isGiftCard', OrderLineRecordRef, OrderLine.FieldNo("Gift Card")); JsonHelper.GetValueIntoField(JOrderLine, 'taxable', OrderLineRecordRef, OrderLine.FieldNo(Taxable)); JsonHelper.GetValueIntoField(JOrderLine, 'originalUnitPriceSet.shopMoney.amount', OrderLineRecordRef, OrderLine.FieldNo("Unit Price")); JsonHelper.GetValueIntoField(JOrderLine, 'originalUnitPriceSet.presentmentMoney.amount', OrderLineRecordRef, OrderLine.FieldNo("Presentment Unit Price")); OrderLineRecordRef.SetTable(OrderLine); OrderLine."Discount Amount" := GetTotalLineDiscountAmount(JsonHelper.GetJsonArray(JOrderLine, 'discountAllocations'), 'shopMoney'); OrderLine."Presentment Discount Amount" := GetTotalLineDiscountAmount(JsonHelper.GetJsonArray(JOrderLine, 'discountAllocations'), 'presentmentMoney'); exit(true); end; local procedure RetrieveAndSetOrderLines(OrderId: BigInteger; var OrderLine: Record "Shpfy Order Line" temporary; var DataCaptureDict: Dictionary of [BigInteger, JsonToken]) var JOrderLines: JsonArray; After: Text; HasNextPage: Boolean; EndCursor: Text; begin repeat RetrieveOrderLinesJson(OrderId, After, JOrderLines, HasNextPage, EndCursor); SetAndInsertOrderLines(OrderId, JOrderLines, OrderLine, DataCaptureDict); After := EndCursor; until not HasNextPage; end; local procedure SetAndInsertOrderLines(OrderId: BigInteger; JOrderLines: JsonArray; var TempOrderLine: Record "Shpfy Order Line" temporary; var DataCaptureDict: Dictionary of [BigInteger, JsonToken]) var JOrderLine: JsonToken; begin foreach JOrderLine in JOrderLines do begin TempOrderLine.Init(); if SetOrderLineValuesFromJson(JOrderLine, OrderId, TempOrderLine) then begin TempOrderLine.Insert(); DataCaptureDict.Add(TempOrderLine."Line Id", JOrderLine); end; end; end; internal procedure TranslateCurrencyCode(ShopifyCurrencyCode: Text): Code[10] var Currency: Record Currency; GeneralLedgerSetup: Record "General Ledger Setup"; CurrencyCode: Code[10]; CurrencyCount: Integer; begin if ShopifyCurrencyCode = '' then exit(''); GeneralLedgerSetup.Get(); if CopyStr(ShopifyCurrencyCode, 1, MaxStrLen(GeneralLedgerSetup."LCY Code")) = GeneralLedgerSetup."LCY Code" then exit(''); Currency.SetLoadFields(Code); Currency.SetRange("ISO Code", CopyStr(ShopifyCurrencyCode, 1, 3)); CurrencyCount := Currency.Count(); if CurrencyCount = 1 then begin Currency.FindFirst(); CurrencyCode := Currency.Code; end else if CurrencyCount > 1 then begin Session.LogMessage('0000S1A', StrSubstNo(DuplicateISOCodeTelemetryLbl, ShopifyCurrencyCode, CurrencyCount), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Currency.FindFirst(); CurrencyCode := Currency.Code; end else if Currency.Get(CopyStr(ShopifyCurrencyCode, 1, MaxStrLen(Currency.Code))) then CurrencyCode := Currency.Code else Session.LogMessage('0000S1B', StrSubstNo(CurrencyNotFoundTelemetryLbl, ShopifyCurrencyCode), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); // Edge case: "LCY Code" is configured as a non-ISO currency code, so the fast path // above did not catch it. Treat the resolved BC currency code as LCY as well. if CurrencyCode = GeneralLedgerSetup."LCY Code" then exit(''); exit(CurrencyCode); end; local procedure ImportCustomAttributtes(ShopifyOrderId: BigInteger; JCustomAttributtes: JsonArray) var OrderAttribute: Record "Shpfy Order Attribute"; JToken: JsonToken; begin OrderAttribute.SetRange("Order Id", ShopifyOrderId); if not OrderAttribute.IsEmpty() then OrderAttribute.DeleteAll(); foreach JToken in JCustomAttributtes do begin Clear(OrderAttribute); OrderAttribute."Order Id" := ShopifyOrderId; OrderAttribute.Key := CopyStr(JsonHelper.GetValueAsText(JToken, 'key', MaxStrLen(OrderAttribute."Key")), 1, MaxStrLen(OrderAttribute."Key")); OrderAttribute."Attribute Value" := CopyStr(JsonHelper.GetValueAsText(JToken, 'value', MaxStrLen(OrderAttribute."Attribute Value")), 1, MaxStrLen(OrderAttribute."Attribute Value")); if not OrderAttribute.Insert() then OrderAttribute.Modify(); end; end; local procedure ImportCustomAttributtes(ShopifyOrderId: BigInteger; OrderLineId: Guid; JCustomAttributtes: JsonArray) var OrderLineAttribute: Record "Shpfy Order Line Attribute"; JToken: JsonToken; begin OrderLineAttribute.SetRange("Order Id", ShopifyOrderId); OrderLineAttribute.SetRange("Order Line Id", OrderLineId); if not OrderLineAttribute.IsEmpty() then OrderLineAttribute.DeleteAll(); foreach JToken in JCustomAttributtes do begin Clear(OrderLineAttribute); OrderLineAttribute."Order Id" := ShopifyOrderId; OrderLineAttribute."Order Line Id" := OrderLineId; OrderLineAttribute.Key := CopyStr(JsonHelper.GetValueAsText(JToken, 'key'), 1, MaxStrLen(OrderLineAttribute."Key")); OrderLineAttribute.Value := CopyStr(JsonHelper.GetValueAsText(JToken, 'value'), 1, MaxStrLen(OrderLineAttribute.Value)); OrderLineAttribute.Insert(); end; end; local procedure ImportRisks(OrderHeader: Record "Shpfy Order Header"; JRiskAssessments: JsonArray) var ShpfyOrderRisks: Codeunit "Shpfy Order Risks"; begin ShpfyOrderRisks.UpdateOrderRisks(OrderHeader, JRiskAssessments); end; /// <summary> /// Description for GetTotalLineDiscountAmount. /// </summary> /// <param name="JDiscountSets">Parameter of type JsonArray.</param> /// <param name="MoneyType">Parameter of type Text.</param> /// <returns>Return variable "Decimal".</returns> local procedure GetTotalLineDiscountAmount(JDiscountSets: JsonArray; MoneyType: Text) Result: Decimal var JDiscountSet: JsonToken; begin foreach JDiscountSet in JDiscountSets do Result += JsonHelper.GetValueAsDecimal(JDiscountSet, 'allocatedAmountSet.' + MoneyType + '.amount'); end; /// <summary> /// Description for CheckToCloseOrder. /// </summary> /// <param name="OrderHeader">Parameter of type Record "Shopify Order Header".</param> /// <returns>Return variable "Boolean".</returns> local procedure CheckToCloseOrder(OrderHeader: Record "Shpfy Order Header"): Boolean var SalesLine: Record "Sales Line"; begin if not Shop."Archive Processed Orders" then exit(false); if ((OrderHeader."Sales Order No." <> '') and (OrderHeader."Fulfillment Status" = OrderHeader."Fulfillment Status"::Fulfilled)) and (OrderHeader."Fully Paid") then begin SalesLine.SetRange("Document Type", SalesLine."Document Type"::Order); SalesLine.SetRange("Document No.", OrderHeader."Sales Order No."); SalesLine.SetFilter("Outstanding Quantity", '<>%1', 0); exit(SalesLine.IsEmpty()); end; exit((OrderHeader."Sales Invoice No." <> '') and (OrderHeader."Fulfillment Status" = OrderHeader."Fulfillment Status"::Fulfilled)); end; /// <summary> /// Description for CloseOrder. /// </summary> /// <param name="OrderHeader">Parameter of type Record "Shopify Order Header".</param> internal procedure CloseOrder(var OrderHeader: Record "Shpfy Order Header") var OrderHeaderRecordRef: RecordRef; JResponse: JsonToken; Parameters: Dictionary of [Text, Text]; begin CommunicationMgt.SetShop(OrderHeader."Shop Code"); Parameters.Add('OrderId', Format(OrderHeader."Shopify Order Id")); JResponse := CommunicationMgt.ExecuteGraphQL("Shpfy GraphQL Type"::Orders_CloseOrder, Parameters); if JsonHelper.GetValueAsBigInteger(JResponse, 'data.orderClose.order.legacyResourceId') = OrderHeader."Shopify Order Id" then begin OrderHeaderRecordRef.GetTable(OrderHeader); JsonHelper.GetValueIntoField(JResponse, 'data.orderClose.order.closed', OrderHeaderRecordRef, OrderHeader.FieldNo(Closed)); if OrderHeaderRecordRef.Field(OrderHeader.FieldNo(Closed)).Value then JsonHelper.GetValueIntoField(JResponse, 'data.orderClose.order.closedAt', OrderHeaderRecordRef, OrderHeader.FieldNo("Closed At")) else OrderHeaderRecordRef.Field(OrderHeader.FieldNo(OrderHeader."Closed At")).Value := 0DT; OrderHeaderRecordRef.Modify(); end; OrderHeader.Validate(Closed, true); OrderHeader.Modify(); end; /// <summary> /// Sets the Salesperson/Purchaser code on the order header based on the specified staff member. /// </summary> /// <param name="ShopCode">The code of the Shopify shop.</param> /// <param name="StaffMemberId">The ID of the staff member.</param> /// <param name="OrderHeaderRecordRef">A reference to the order header record to update.</param> local procedure SetSalespersonOnOrderHeader(ShopCode: Code[20]; StaffMemberId: BigInteger; var OrderHeaderRecordRef: RecordRef) var StaffMember: Record "Shpfy Staff Member"; OrderHeader: Record "Shpfy Order Header"; begin if not StaffMember.Get(ShopCode, StaffMemberId) then exit; OrderHeaderRecordRef.Field(OrderHeader.FieldNo("Salesperson Code")).Value := StaffMember."Salesperson Code"; end; /// <summary> /// Description for GetName. /// </summary> /// <param name="FirstName">Parameter of type Text.</param> /// <param name="LastName">Parameter of type Text.</param> /// <param name="CompanyName">Parameter of type Text.</param> /// <returns>Return variable "Text".</returns> local procedure GetName(FirstName: Text; LastName: Text; CompanyName: Text) Result: Text var IName: Interface "Shpfy ICustomer Name"; begin IName := Shop."Name Source"; Result := IName.GetName(FirstName, LastName, CompanyName); if Result = '' then begin IName := Shop."Name 2 Source"; Result := IName.GetName(FirstName, LastName, CompanyName); end; end; /// <summary> /// Description for GetName2. /// </summary> /// <param name="FirstName">Parameter of type Text.</param> /// <param name="LastName">Parameter of type Text.</param> /// <param name="CompanyName">Parameter of type Text.</param> /// <returns>Return variable "Text".</returns> local procedure GetName2(FirstName: Text; LastName: Text; CompanyName: Text) Result: Text var IName: Interface "Shpfy ICustomer Name"; begin IName := Shop."Name 2 Source"; Result := IName.GetName(FirstName, LastName, CompanyName); if Result = GetName(FirstName, LastName, CompanyName) then Result := ''; end; local procedure GetContactName(FirstName: Text; LastName: Text; CompanyName: Text) Result: Text var IName: Interface "Shpfy ICustomer Name"; begin IName := Shop."Contact Source"; Result := IName.GetName(FirstName, LastName, CompanyName); end; local procedure ConvertToFinancialStatus(Value: Text) FinancialStatus: Enum "Shpfy Financial Status" var IsHandled: Boolean; begin OrderEvents.OnBeforeConvertToFinancialStatus(Value, FinancialStatus, IsHandled); if IsHandled then exit; Value := CommunicationMgt.ConvertToCleanOptionValue(Value); if Enum::"Shpfy Financial Status".Names().Contains(Value) then exit(Enum::"Shpfy Financial Status".FromInteger(Enum::"Shpfy Financial Status".Ordinals().Get(Enum::"Shpfy Financial Status".Names().IndexOf(Value)))) else exit(Enum::"Shpfy Financial Status"::Unknown); end; local procedure ConvertToFulfillmentStatus(Value: Text) OrderFulfillStatus: Enum "Shpfy Order Fulfill. Status" var IsHandled: Boolean; begin OrderEvents.OnBeforeConvertToFulfillmentStatus(Value, OrderFulfillStatus, IsHandled); if IsHandled then exit; Value := CommunicationMgt.ConvertToCleanOptionValue(Value); if Enum::"Shpfy Order Fulfill. Status".Names().Contains(Value) then exit(Enum::"Shpfy Order Fulfill. Status".FromInteger(Enum::"Shpfy Order Fulfill. Status".Ordinals().Get(Enum::"Shpfy Order Fulfill. Status".Names().IndexOf(Value)))) else exit(Enum::"Shpfy Order Fulfill. Status"::" "); end; local procedure GetOrderDueDate(JPaymentSchedules: JsonArray): Date var JPaymentSchedule: JsonToken; begin if JPaymentSchedules.Count = 1 then if JPaymentSchedules.Get(0, JPaymentSchedule) then exit(JsonHelper.GetValueAsDate(JPaymentSchedule, 'dueAt')); end; local procedure ConvertToCancelReason(Value: Text): Enum "Shpfy Cancel Reason" begin Value := CommunicationMgt.ConvertToCleanOptionValue(Value); if Enum::"Shpfy Cancel Reason".Names().Contains(Value) then exit(Enum::"Shpfy Cancel Reason".FromInteger(Enum::"Shpfy Cancel Reason".Ordinals().Get(Enum::"Shpfy Cancel Reason".Names().IndexOf(Value)))) else exit(Enum::"Shpfy Cancel Reason"::" "); end; local procedure UpdateLocationIdAndDeliveryMethodOnOrderLine(var OrderLine: Record "Shpfy Order Line") var FulfillmentOrderLine: Record "Shpfy FulFillment Order Line"; begin FulfillmentOrderLine.Reset(); FulfillmentOrderLine.SetRange("Shopify Order Id", OrderLine."Shopify Order Id"); FulfillmentOrderLine.SetRange("Line Item Id", OrderLine."Line Id"); FulfillmentOrderLine.SetFilter("Fulfillment Status", '<>%1', 'CLOSED'); if not FulfillmentOrderLine.IsEmpty() then UpdateLocationIdAndDeliveryMethodOnOrderLines(OrderLine, FulfillmentOrderLine) else begin FulfillmentOrderLine.SetRange("Fulfillment Status"); UpdateLocationIdAndDeliveryMethodOnOrderLines(OrderLine, FulfillmentOrderLine); end; end; local procedure UpdateLocationIdAndDeliveryMethodOnOrderLines(var OrderLine: Record "Shpfy Order Line"; var FulfillmentOrderLine: Record "Shpfy FulFillment Order Line") var TotalQuantity: Integer; begin if FulfillmentOrderLine.FindSet() then begin repeat TotalQuantity += FulfillmentOrderLine."Total Quantity"; until FulfillmentOrderLine.Next() = 0; if TotalQuantity = OrderLine.Quantity then begin OrderLine."Location Id" := FulfillmentOrderLine."Shopify Location Id"; OrderLine."Delivery Method Type" := FulfillmentOrderLine."Delivery Method Type"; end; end; end; local procedure ConvertToOrderReturnStatus(Value: Text) OrderReturnStatus: Enum "Shpfy Order Return Status" var IsHandled: Boolean; begin OrderEvents.OnBeforeConvertToOrderReturnStatus(Value, OrderReturnStatus, IsHandled); if IsHandled then exit; Value := CommunicationMgt.ConvertToCleanOptionValue(Value); if Enum::"Shpfy Order Return Status".Names().Contains(Value) then exit(Enum::"Shpfy Order Return Status".FromInteger(Enum::"Shpfy Order Return Status".Ordinals().Get(Enum::"Shpfy Order Return Status".Names().IndexOf(Value)))) else exit(Enum::"Shpfy Order Return Status"::" "); end;}