Skip to main content
Answer

How can we save huge xml response into DB?

  • January 6, 2021
  • 3 replies
  • 94 views
L
Freshman I

Hi All,

I want to save the huge xml response in SQL Server.

At present, I am trying to convert total xml response to string and saving to DB, but here total response is not saving as the content is very very big.
So want to try like saving the response as it is like xml. Is it possible to save like this.. If yes may I know the possibilities / approaches please.


Thanks in advance.

Best answer by FredZhou

basically, XML is stored in string format. people will store XML in a folder, then in data store the url/directory into database.

    3 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • January 6, 2021

    Hi @lakshmim85,

    Can you please share the sample XML response file here, will try and let you know if I found anything from myside.

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    L
    Freshman I
    • lakshmim85
    • Author
    • Freshman I
    • January 7, 2021

    Hi @Naveen B ,

    Please find the xml response as an attachment here. 

    Thank you!

    1 Attachments
    F
    Freshman I
    • FredZhou
    • Freshman I
    • Answer
    • February 11, 2021

    basically, XML is stored in string format. people will store XML in a folder, then in data store the url/directory into database.

    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved