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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

API Import - Date format

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • KasparsSemjonovs Profile Picture
    4,766 Super User 2025 Season 2 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
    95,634 Super User 2025 Season 2 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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans