Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / API-Encoding-Problem
Small and medium business | Business Central, N...
Unanswered

API-Encoding-Problem

(0) ShareShare
ReportReport
Posted on by Hinnack 69
 
Hello There, 
 
I have the following problem: We have implemented a page (incl. table) of type /API/ in our Business Central 365 environment (SaaS), which should receive posting information from an external financial accounting. This data is then further processed in a separate process. It is now the case that posting texts (freely fillable by the clerk) are also part of this posting information. Since we are in the German language area, it can happen that German umlauts are used in these posting texts. If we now want to use a simple Powershell script to transfer this data from the source system to the target system via an API call, the umlauts are not resolved correctly. Thus a /ü/ becomes a ///u00fc/ in the target column. We use (for test purposes) the following Powershell script:
 
 
 
After the transfer to Business Central 365 (SaaS) we get the following value for /BUCHUNGSTEXT/ in the target table:
 
 
////enter///
 

We would have expected the transferred /BUCHUNGSTEXT/ to appear in Business Central as we specified it.

We are urgently looking for a possible solution. Thank you very much for your support.

Categories:
Business Central
Business Central
Business Central
  • Ram Pranav Profile Picture
    Ram Pranav 50 on at
    API-Encoding-Problem
    Hi Hinnack,
     
    Can you please share a screenshot of the field added in the API Page? Please remove any other sensitive information.
     
    Regards,
    Ram Pranav.
  • Hinnack Profile Picture
    Hinnack 69 on at
    API-Encoding-Problem
    If we use the standard API it also works. But we use a custom API.  Apparently there is a difference between standard and custom API.
  • YUN ZHU Profile Picture
    YUN ZHU 73,035 Super User 2024 Season 2 on at
    API-Encoding-Problem
    Hi, I did a simple test in Postman and didn't encounter your problem. Hope the information below can give you some hints.
     
    More details:
     
    Thanks
    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans