Developer forum

Forum » Integration » Live Integration Prices in different Currencies

Live Integration Prices in different Currencies

E-mail notifications
Justin Sjouw Dynamicweb Employee
Justin Sjouw
Reply
Posted on 07/03/2022 10:07:06

Hello,

I have a solution with several languages. In English alle seems to work fine, products are shown and the prices are requested via the Live Integration. 

In any other language than english no prices are shown. When I check the LiveIntegration logs I see the following for a Live Integration Call in English:

And this is the log for another lanugage, in this case Danish:

When I try to get a price from Business Central with the testtool as described in the documentation with this request:

<GetEcomData ExternalUserId="C220007" AccessUserCustomerNumber="1666">
  <tables>
    <Products type="filter" unitPrices="true">
      <Product>
        <ProductId>2101</ProductId>
        <ProductVariantId></ProductVariantId>
        <ProductNumber>2101</ProductNumber>       
        <ProductIdentifier>2101..LANG1</ProductIdentifier> 
        <CurrencyCode>DKK</CurrencyCode>
        <Quantity>1</Quantity>
      </Product>
    </Products>
  </tables>
</GetEcomData>

I get The following Valid result

<?xml version="1.0" encoding="utf-16"?>
<tables version="1.2.0.8_NAV10.0.18609">
  <table tableName="EcomProducts">
    <item table="EcomProducts">
      <column columnName="ProductId"><![CDATA[2101]]></column>
      <column columnName="ProductVariantId"><![CDATA[]]></column>
      <column columnName="ProductIdentifier"><![CDATA[2101..LANG1]]></column>
      <column columnName="ProductNumber"><![CDATA[2101]]></column>
      <column columnName="ProductName"><![CDATA[Comfort Blue Premium spuitzakken,]]></column>
      <column columnName="ProductPrice"><![CDATA[1,499.985]]></column>
      <column columnName="ProductStock"><![CDATA[105]]></column>
      <column columnName="ProductCurrencyCode"><![CDATA[DKK]]></column>
      <column columnName="ProductDefaultUnitId"><![CDATA[Unit_OMDOOS]]></column>
    </item>
  </table>
  <table tableName="EcomPrices">
    <item table="EcomPrices">
      <column columnName="PriceProductId"><![CDATA[2101]]></column>
      <column columnName="PriceUserCustomerNumber"><![CDATA[1666]]></column>
      <column columnName="PriceProductUnitId"><![CDATA[Unit_OMDOOS]]></column>
      <column columnName="PriceQuantity"><![CDATA[1]]></column>
      <column columnName="PriceAmount"><![CDATA[1,499.985]]></column>
    </item>
  </table>
</tables>

This makes me think the problem is not in BC, but I am not sure where to look. 

Any idea's?

Thanks,

Justin


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 07/03/2022 13:55:45
Reply

Hi Justin,
when you are doing the request from the live integration the xml looks like this:
DebugInfo: Request GetProductsInfo sent: '<?xml version="1.0" encoding="UTF-8" standalone="yes"?><GetEcomData ExternalUserId="D00002" AccessUserCustomerNumber="D00002"><tables><Products type="filter"><Product><ProductId>V2999306</ProductId><ProductVariantId></ProductVariantId><ProductNumber>V2999306</ProductNumber><ProductIdentifier>V2999306..DAN</ProductIdentifier><CurrencyCode>DKK</CurrencyCode><Quantity>1</Quantity><Brand isCustomField="True"></Brand><OldProductNumber isCustomField="True"></OldProductNumber><ProductCategoryCode isCustomField="True"></ProductCategoryCode><ID isCustomField="True"></ID><ProductRentalPrice isCustomField="True">0</ProductRentalPrice></Product></Products></tables></GetEcomData>'
So maybe your live integration is totally custom? or you have some custom live integration that subscribes to the standard live integration and overrides the behavior
so you get some wrong request string?
BR, Dmitrij

 
Justin Sjouw Dynamicweb Employee
Justin Sjouw
Posted on 07/03/2022 13:58:56
Reply

Hi Dmitrij,

The solution is fully standard as far as I know.

I will PM you the URL and login so maybe you can have a look?

Thanks,

Justin

 

You must be logged in to post in the forum