Dynamics User Group
Dynamics User Group
  • Site
  • User
  • Site
  • Search
  • User
Dynamics 365 for Finance and Operations/AX User Group
Dynamics 365 for Finance and Operations/AX User Group
Dynamics NAVAX
  • Forums
  • Blogs
  • More
  • Cancel
  • New
Dynamics 365 for Finance and Operations/AX User Group requires membership for participation - click to join (it's free)
Dynamics NAVAX
All things Dynamics AX
  • Home
  • Contact author
  • Subscribe by email
  • More
  • Cancel
  • Posts RSS
  • Atom
  • More
  • Cancel
Monthly archive list
  • November 2020 (1)
  • October 2020 (1)
  • September 2020 (1)
  • June 2020 (2)
  • May 2020 (1)
  • April 2020 (1)
  • January 2020 (1)
  • October 2019 (1)
  • September 2019 (1)
  • July 2019 (2)
  • June 2019 (1)
  • April 2019 (3)
  • February 2019 (1)
  • January 2019 (2)
  • November 2018 (1)
  • October 2018 (3)
  • September 2018 (5)
  • August 2018 (1)
  • July 2018 (1)
  • June 2018 (2)
  • May 2018 (2)
  • April 2018 (3)
  • March 2018 (1)
  • January 2018 (4)
  • December 2017 (3)
  • November 2017 (1)
  • October 2017 (2)
  • September 2017 (2)
  • August 2017 (2)
  • July 2017 (5)
  • June 2017 (2)
  • May 2017 (1)
  • April 2017 (1)
  • March 2017 (2)
  • February 2017 (1)
  • January 2017 (3)
  • December 2016 (2)
  • November 2016 (6)
  • October 2016 (6)
  • September 2016 (4)
  • August 2016 (1)
  • July 2016 (1)
  • June 2016 (2)
  • May 2016 (1)
  • April 2016 (4)
  • July 2012 (1)
  • June 2012 (4)
  • May 2012 (2)
  • April 2012 (4)
  • March 2012 (6)
  • February 2012 (4)
  • January 2012 (5)
  • November 2011 (1)
  • July 2011 (2)
  • June 2011 (5)
  • May 2011 (1)
Related
Related Tags
  • Android
  • ApiApp
  • AX
  • AX X++
  • AX2012
  • AX2012R3
  • ax7
  • Azure
  • D365O
  • Development
  • Dyn365FO
  • Dynamics 365 For Operations
  • Flow
  • General
  • Integration
  • iPhone
  • Mobile
  • MSDyn365FO
  • Restful
  • SOAPUI
  • Tip
  • WebServices
  • Workflow
  • X++
  • Xpp
Blog post list
  • Tags
  • Contact author
  • Subscribe by email
  • More
  • Cancel
  • Business Events and Date format in Flow

    munib
    munib
    Business Events formats Dates in the Microsoft JSON format, e.g. "EventTime": "/Date(1560839609000)/" I wish it was in ISO8601 standard e.g. "2019-06-18T05:40Z". Below is what I did using Flow. First get the integer part of the string by using the replace function. Function: int(replace(replace('/Date(1560839609000)/','/Date(',''), ')/', '')) Output: 1560839609000 To format into date. Function: addseconds('1970-1-1', Div(1560839609000,1000) , 'yyyy-MM-dd') Output: 2019-06-18 To format into datetime. Function: addseconds('1970-1-1', Div(1560839609000,1000) , 'yyyy-MM-dd hh:mm:ss') Output: 2019-06…
    • 2019-7-4
    • Original post
    • MSDyn365FO
    • Flow
    • 13 views
    • 0 comments
    • over 1 year ago
    • More
    • Cancel
  • Data Management Export - XML to JSON Transformation

    munib
    munib
    In my last post, I wrote about event based integration using Business Events . I used JSON as my export file type. JSON is a lot easier to work with in Microsoft Flow or Azure LogicApp. Below is how I achieved it. Data Management framework doesn’t do JSON by default. However, it does do XML file format. A bit of googling and trial and error. I found this XSLT code that transformed XML to JSON. https://gist.github.com/bojanbjelic/1632534 Here is the authors blog post to give credit. https://www.bjelic.net/2012/08/01/coding/convert-xml-to-json-using-xslt/#code Setup Under the Data management workspace…
    • 2019-7-2
    • Original post
    • MSDyn365FO
    • Flow
    • Logic
    • Integration
    • Azure
    • 15 views
    • 0 comments
    • over 1 year ago
    • More
    • Cancel
  • Microsoft Dynamics 365 User Groups

  • Dynamics 365 Business Central
  • Dynamics 365 Customer Engagement
  • Dynamics 365 for Finance and Operations
  • Power Platform
  • Microsoft Dynamics User Groups

  • Dynamics AX
  • Dynamics CRM
  • Dynamics NAV
  • About
  • Contact us
  • Frequently asked questions
  • Terms of use
  • Privacy policy
Copyright 1995-2021 Dynamics User Group, all rights reserved.
EU Cookie Consent
  • DUG Home
    • Contact DUG
  • Dynamics 365 for Finance and Operations/AX User Group
    • Forums
    • Blogs
  • Dynamics 365 Business Central/NAV User Group
    • Forums
    • Blogs
    • Wikipedia
    • Events
  • About DUG
    • Announcements
    • Frequently asked questions about DUG
    • Membership service
    • Advertise on DUG
    • Become a DUG sponsor
    • Follow us on LinkedIn
    • Follow us on Facebook
    • Follow us on Twitter
  • More
  • Cancel