0
votes

I am new to using acumatica web service. is it possible to upload a document/ file in specific screen as attachment like business account attachment.

eg. below screen in which we add manually.

enter image description here

2
Are you using Screen-Based or Contact-Based API?RuslanDev
screen based api but i solved using attachment command and convert file into base64Mitesh Machhi

2 Answers

2
votes

I find the solution and posted to help anyone. To upload any file we must convert that file into bytes and submit bytes which convert your file.

             //Get bytes of file

             byte[] filedata;
             using(System.IO.FileStream file =
             System.IO.File.Open(@"D:\Test.pdf",System.IO.FileMode.Open)) 
             {
                 filedata = new byte[file.Length];
                 file.Read(filedata,0,filedata.Length);
             }

            //   Import Data Now to Business Account

                BAccount.CR303000ImportResult[] lstObjContent = context.CR303000Import
               (
                new BAccount.Command[]
               {
                 // Must Pass BusinessAccount in which we want to update or add data
                 new BAccount.Value { Value="XXXXXX",LinkedCommand=objContent.AccountSummary.BusinessAccount},
                 new BAccount.Value { Value="TestValue123",LinkedCommand=objContent.AccountSetup.CurrentMethod},
                 new BAccount.Value { FieldName="NameOfFileWithExtension",LinkedCommand=objContent.AccountSummary.ServiceCommands.Attachment},
                 objContent.Actions.Save
                },null,new string[][] { new string[] { Convert.ToBase64String(filedata) },new string[] { Convert.ToBase64String(filedata) },}
                 ,false,false,true
            );
1
votes

Even the below code works. Verified in version 18R1.

 var content = _context.CR306000GetSchema(); _context.CR306000Clear();

 var commands = new List();

 ReqParameter(content, ref commands);

 commands.Add(content.Actions.Save);

 commands.Add(content.CaseSummary.CaseID);

 var orderResults = _context.CR306000Submit(commands.ToArray());

 private static void ReqParameter(CR306000Content content, ref List<Command> cmds)
    {
        if (cmds == null) throw new ArgumentNullException("cmds");        

        byte[] filedata= null;            
        Uri uri = new Uri("https://acmdev.baccahq.com/Icons/login_bg5.jpg");  // change the required url of the data that has to be fetched 

        if (uri.IsFile)
        {
            string filename = System.IO.Path.GetFileName(uri.LocalPath);
            filedata = System.Text.Encoding.UTF8.GetBytes(uri.LocalPath);
        }
        if (filedata == null)
        {
            WebClient wc = new WebClient();
            filedata = wc.DownloadData(uri);
        }

        cmds = new List<Command>
        {

            //Case Header Details
            new Value { Value="<NEW>",LinkedCommand = content.CaseSummary.CaseID},
            new Value { Value="L41",LinkedCommand = content.CaseSummary.ClassID},
            new Value { Value="ABCSTUDIOS",LinkedCommand = content.CaseSummary.BusinessAccount, Commit = true},          
            new Value { Value="Test subject created from envelop call 11C",LinkedCommand = content.CaseSummary.Subject},           

            // body of the case 
            new Value{Value= "Body of the content for created through envelop call 11B", LinkedCommand = content.Details.Description},


            //Attaching a file
            new Value
            {
                Value = Convert.ToBase64String(filedata),   // byte data that is passed to through envelop 
                FieldName = "Test.jpg",
                LinkedCommand =
            content.CaseSummary.ServiceCommands.Attachment
            },


         };
    }