Finance | Project Operations, Human Resources, ...

XML file not uploading to blob

(1) Share

Report

Posted on by PriyaDutta

351

Hi All,

I am trying to upload my xml to blob storage. It is getting uploaded but the file size is 3B. I am suspecting the stream has null value sue to which the xml is not appearing.

Please find the below code I have written.

  streamIO.write(xmlDoc);
 
  XX_VendPaymIntegrationHelper::uploadToBlob(parameters.BlobStorageConnectionString,
                                              parameters.BlobStorageContainer,
                                             parameters.BlobStorageOutboundFolder,
                                             fileName,
                                             streamIO,xmlDoc);

  public static void uploadToBlob(HS_VendPaymIntBlobStorageConnectionString _connectionString,
                                     HS_VendPaymIntBlobStorageContainer _container,
                                     HS_VendPaymBlobStorageOutboundFolder _folder,
                                     Filename _filename,
                                     CommaTextStreamIo _streamIO, XMLDocument _xmlDoc )
  {
      try
      {
          CloudStorageAccount storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount::Parse(_connectionString);
          CloudBlobClient     blobClient = storageAccount.CreateCloudBlobClient();
          CloudBlobContainer  blobContainer = blobClient.GetContainerReference(_container);
          //blobContainer.CreateIfNotExists(null, null); //create blob container

          Filename            fullName = _folder ? _folder + "/" + _filename : _filename;
          CloudBlockBlob      destBlob = blobContainer.GetBlockBlobReference(fullName);
          System.IO.MemoryStream memstream = _streamIO.getstream();
          destBlob.UploadFromStream(memstream, null, null, null);

          
      
      }
      catch
      {
          throw error("Blob error");
      }
  }

Please help.

Thanks,

Priya

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Martin Dráb 239,747 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Well, if you suspect that _streamIO is empty, test it. We can't do it for you; you're the only one who can run your complete code.

By the way, it's possible that you've written data successfully to the stream but it's object is pointing to the end of the stream, therefore you need to reset the position to the beginning of the stream. It may be as simple as assigning 0 to the Position property (depending on the type of the stream).

By the way, which version of AX is it about?

Was this reply helpful? Yes No
PriyaDutta 351 on at

Like (0)

Report
Copy link

Link copied!
Hi Martin,

I have tried adding position=0 but same issue.

try { CloudStorageAccount storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount::Parse(_connectionString); CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); CloudBlobContainer blobContainer = blobClient.GetContainerReference(_container); //blobContainer.CreateIfNotExists(null, null); //create blob container Filename fullName = _folder ? _folder + "/" + _filename : _filename; CloudBlockBlob destBlob = blobContainer.GetBlockBlobReference(fullName); System.IO.MemoryStream memstream = _streamIO.getstream(); memstream.Position = 0; destBlob.UploadFromStream(memstream, null, null, null); }

The question is it this the correct way to write to stream ? Is there any alternative to convert the xml file to stream ?

streamIO.write(xmlDoc);

And I am using D365FO.

Was this reply helpful? Yes No
Martin Dráb 239,747 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You should do more work on the the problem isolation, instead of just trying random pieces of code. For instance, you said you might have no data written to _streamIO. If it's the case, resetting the position won't help you - it won't change the fact that you haven't written anything to the stream. But maybe your assumption is wrong and you actually have data there. You should test the assumption, e.g. by looking at the Length property of the stream.

Regarding your question about streamIO.write(xmlDoc), what is the data type of your xmlDoc variable?

Was this reply helpful? Yes No
PriyaDutta 351 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

I debugged the code and Length is= 3

Xmldoc is of XMLDocument datatype.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,747 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
You may mean either the X++ class XMLDocument or .NET class System.Xml.XmlDocument. In either case, writing the object reference to a stream is wrong.

Use writeTo() method of the document object instead.

For example:

System.IO.MemoryStream stream = new System.IO.MemoryStream(); XmlWriter xmlWriter = XmlWriter::newStream(stream); xmlDoc.writeTo(xmlWriter); writer.flush();

Was this reply helpful? Yes No
PriyaDutta 351 on at

Like (0)

Report
Copy link

Link copied!
Hi Martin,

I tried the below example you suggested. Now the blob file shows 0B .

Please see the below code for reference.

public static void uploadToBlob(HS_VendPaymIntBlobStorageConnectionString _connectionString, HS_VendPaymIntBlobStorageContainer _container, HS_VendPaymBlobStorageOutboundFolder _folder, Filename _filename,, xmldocument _xmlDoc ) { try { CloudStorageAccount storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount::Parse(_connectionString); CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); CloudBlobContainer blobContainer = blobClient.GetContainerReference(_container); //blobContainer.CreateIfNotExists(null, null); //create blob container Filename fullName = _folder ? _folder + "/" + _filename : _filename; CloudBlockBlob destBlob = blobContainer.GetBlockBlobReference(fullName); System.IO.MemoryStream stream = new System.IO.MemoryStream(); XmlWriter xmlWriter = XmlWriter::newStream(stream); _xmlDoc.writeTo(xmlWriter); xmlWriter.flush(); destBlob.UploadFromStream(stream, null, null, null); } catch { throw error("Blob error"); } }

Please help.

Thanks,

Priya

Was this reply helpful? Yes No
Martin Dráb 239,747 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

As you see, if you look just at the final result, you have no idea where your code failed. You need to debug it to get a better idea where things went wrong. I can't debug it for you. For example, it's possible that the code you showed us is perfect but you have nothing in _xmlDoc. I don't know; you didn't tell us anything about testing it.

If I was you, I would test whether the data is written to the stream. If not, there is no point trying to write it to a blob and checking the size, because you already know you have no data to write. But if it's there, you'll know that your problem is in writing to the blob, not to the stream. This is an example of how you can isolate the problem.

By the way, it would be better (both for you and the people you share your code with) if you created a simple, standalone example that can be executed.

Was this reply helpful? Yes No