Any workaround for upsert in OData/Logic App

(0) Share

Report

Posted on by prkr

Hi Folks,

I have a requirement to synchronize customers, addresses, contacts, Notes etc as continous integration from 3rd party app to FinOps. I could not find any Dynamics 365 for FinOps Odata connector in Logic App for upsert. Any workaround to avoid several calls Get a record, Create a record and Update a record on multiple data entities?

Any thoughts?

I have the same question (0)

All responses (7)

Answers (2)

A.Prasanna 8,223 on at

Like (0)

Report

this might help: marketplace.visualstudio.com/items

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

Amith, could you please explain how it could help? Just mentioning a whole website isn't very useful - please point to the relevant piece (if there is any).

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi prkr,

I believe if you want to use oData you don't have any other workarounds except getting record first with GET request and based response decide on insert or update. What is your concern in additional GET? Do you have high-volume integration in this area?

Was this reply helpful? Yes No
Verified answer

WillWU 22,363 on at

Like (0)

Report

Hi prkr,

Agree with Sergei, I think you have to create a get a record connector in D365FO and there are no triggers for D365 FO in logic app.

If you want your data entity do an incremental export, you can try to configuring the entity export option use BYOD.

See the change tracking for incremental push:

docs.microsoft.com/.../export-entities-to-your-own-database

Was this reply helpful? Yes No
prkr 90 on at

Like (0)

Report

There are multiple D365FO OData calls to several customer related data entities endpounts on incoming JSOn data. Thoughts was to avoid mulyiple calls for Get/Insert or Update. Can OData actions be utilized to shift the logic to OData actions?

Any thoughts?

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi prkr,

oData actions and web services can be utilize to receive some input parameters and based on this make insert or update but it's much harder to support them comparing to entities and you need to develop them.

Was this reply helpful? Yes No
@frankrasta 30 on at

Like (0)

Report

Hi,

Maybe this code help you:

public void CreateSalesOrderOneTrans()

{

string salesOrderNumber = "";

string company = "agr";

string itemId = "";

int rowCount = 0;

try

{

SalesOrderHeader salesOrder = new SalesOrderHeader();

DataServiceCollection<SalesOrderHeader> salesOrderCollection = new DataServiceCollection<SalesOrderHeader>(context);

salesOrderCollection.Add(salesOrder);

//salesOrder.SalesOrderNumber = salesOrderNumber; // Change number sequence setting in AX to allow user to set values.

salesOrder.CurrencyCode = "UYU";

salesOrder.OrderingCustomerAccountNumber = "ABT-000001";

salesOrder.DataAreaId = company;

//Save salesorder

context.MergeOption = MergeOption.OverwriteChanges;

context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset);

//Take Sales order next number sequence

salesOrderNumber = salesOrder.SalesOrderNumber;

//Address

/*

salesOrder.DeliveryAddressName = "Uruguay";

salesOrder.DeliveryAddressStreet = "street 123";

salesOrder.DeliveryAddressCity = "Montevideo";

salesOrder.DeliveryAddressStreetNumber = "876";

*/

#region SalesOrderLine

DataServiceCollection<SalesOrderLine> salesOrderLineCollection = new DataServiceCollection<SalesOrderLine>(context);

SalesOrderLine salesOrderLine;

while (rowCount <= 1)

{

salesOrderLine = new SalesOrderLine();

salesOrderLineCollection.Add(salesOrderLine);

//salesOrder is updated through save operation before, so i can assign the correct Operations generated SalesOrderNumber to the line

salesOrderLine.SalesOrderNumber = salesOrder.SalesOrderNumber;

salesOrderLine.OrderedSalesQuantity = rowCount;

salesOrderLine.DataAreaId = company;

//salesOrderLine.SalesUnitSymbol = UnitOfMeasureCodeSymbol.Kilograms.ToString();

itemId = (rowCount == 1) ? "011" : "020";

if (itemId == "011")

{

salesOrderLine.ItemNumber = itemId;

salesOrderLine.ShippingSiteId = "BG";

salesOrderLine.ShippingWarehouseId = "wert";

salesOrderLine.ShippingWarehouseLocationId = "Production";

}

else

{

salesOrderLine.ItemNumber = itemId;

salesOrderLine.ShippingSiteId = "BG";

salesOrderLine.ShippingWarehouseId = "poi";

}

rowCount++;

}

#endregion

context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset);

Console.WriteLine(string.Format("SalesOrder {0} - Saved !", salesOrder.SalesOrderNumber));

}

catch (DataServiceRequestException e)

{

Console.WriteLine(string.Format("SalesOrder {0} - Save Failed !", "Error"));

}

}

regards ,

Was this reply helpful? Yes No