web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / API Import - Date format
Small and medium business | Business Central, N...
Suggested Answer

API Import - Date format

(0) ShareShare
ReportReport
Posted on by Community member 13
hello,
 
while importingthrough an Extension to MBC - SalesPricing Table 7002
i always get this error notice: 



Die Konvertierung von Microsoft.Dynamics.Nav.Runtime.NavText in System.DateTime ist nicht möglich.

Interne Sitzungs-ID:
fc1bae08-7b2e-4f2b-890c-42cbcb7c63be

Application Insights-Sitzungs-ID:
bc7af85e-125d-48e7-ac67-a624929b50f0

Client-Aktivitäts-ID:
58075e34-dbeb-4d82-856e-dbddbe860587

Zeitstempel bei Fehler:
2023-07-19T05:43:15.4157601Z

Al-Aufrufliste:
PFNRel2BCIntegrationMgt(CodeUnit 71057702).SetFieldFilter line 35 - Perfion PIM - Release2ERP by Perfion
PFNRel2BCIntegrationMgt(CodeUnit 71057702).ProcessTable line 46 - Perfion PIM - Release2ERP by Perfion
PFNRel2BCIntegrationMgt(CodeUnit 71057702).ProcessSectionStep line 20 - Perfion PIM - Release2ERP by Perfion
PFNRel2BCIntegrationMgt(CodeUnit 71057702).ProcessXmlNode line 26 - Perfion PIM - Release2ERP by Perfion
PFNRel2BCIntegrationMgt(CodeUnit 71057702).ProcessXmlNodeList line 14 - Perfion PIM - Release2ERP by Perfion
PFNRel2BCIntegrationMgt(CodeUnit 71057702).ProcessQuery line 32 - Perfion PIM - Release2ERP by Perfion
PFNRel2BCIntegrationMgt(CodeUnit 71057702).ExecuteQuery line 25 - Perfion PIM - Release2ERP by Perfion
PFNRel2BCIntegration(Table 71057703).ExecuteQuery line 4 - Perfion PIM - Release2ERP by Perfion
PFNRel2BCIntegrationCard(Page 71057705)./ExecuteQuery - OnAction/(Trigger) line 2 - Perfion PIM - Release2ERP by Perfion

 

 

I suppose it has to do something with the format of the date.

the ironic thing about it is, that i do not need the date in the table at all, because we have another work-around for the time stamps.

anyone could provide me a suggestion how to get rid of it?

 

my best,

 

frantsiek

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,807 Super User 2026 Season 1 on at
    Try to change Your date format in the Regional Settings - try several options and check if the error changes /disappears? 
    If it is on-prem system - then check the server/instance date format and make the same.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 97,376 Super User 2026 Season 1 on at
    Hi, it is recommended that you use Get method first to see the date format returned in your environment, and then import in that date format when you import via API.
     
     
    Hope this helps.
    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

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,042 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,077 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,068 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans