Solved

How can we save huge xml response into DB?

  • 6 January 2021
  • 3 replies
  • 77 views
L
Rank

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.

icon

Best answer by FredZhou 11 February 2021, 01:06

View original

3 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

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
L
Rank

Hi @Naveen B ,

Please find the xml response as an attachment here. 

Thank you!

1 Attachment
F
Rank

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

Reply


Terms & ConditionsCookie settings
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