Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

API Import - Date format

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

Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    API Import - Date format
    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
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    API Import - Date format
    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans