Method Community

I have followed the sample code here: https://www.method.me/cs/forums/t/949.aspx

string result = ssc.MethodAPIUpdateFile(Constants.CompanyId, textBoxMethodUsername.Text, textBoxMethodPassword.Text,

"", Constants.MethodCustomerTable, new string[ { "IdCardPhoto" }, image, "rocket.jpg", "276");

Where my Company Id is ACMG1 and the table is Customer where I added an IdCardPhoto column of type Picture.  No matter what I change (smaller picture, File datatype instead of Picture, deleting the column and re-adding it) I get the following error message:

<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "There were problems with running the query. Please try again. If this message continues to appear, please contact support." ></MethodAPI>

The Id 276 definitely exists because if I upload a picture via the Web UI, this returns the picture properly:

result = ssc.MethodAPISelect_DataSetV2(Constants.CompanyId, textBoxMethodUsername.Text, textBoxMethodPassword.Text, "", ref ds, Constants.MethodCustomerTable, "IdCardPhoto, IdCardPhotoFileName, FullName", "RecordID=276", "", "", "");

Any suggestions?  Are their any special SOAP settings I need to upload the byte[ that I need to put in my app.config file?

Thanks,

Bob

Hi Bob,

Can you please post up the complete code snippet that you are using (including the portion used to create the byte array)?  We can have a look at the code as whole and then try replicating the issue on our end. 

Cheers

Here you go:

byte[] image = null;

FileStream fs = new FileStream("rocket16.png", FileMode.Open, FileAccess.Read);

BinaryReader br = new BinaryReader(fs);

long numBytes = new FileInfo("rocket16.png").Length;

image = br.ReadBytes((int)numBytes);

ACMGSyncMethodToWebSite.MethodCRM.ServiceSoapClient ssc = new MethodCRM.ServiceSoapClient("ServiceSoap");

string result = ssc.MethodAPIUpdateFile(Constants.CompanyId, textBoxMethodUsername.Text, textBoxMethodPassword.Text, "",

Constants.MethodCustomerTable, new string[] { "IdCardPhoto" }, image, "rocket.png", "276");

The result I get is: 

<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "There were problems with running the query. Please try again. If this message continues to appear, please contact support." ></MethodAPI>

Thanks,

Bob

My apologies for the late reply boblutz. 

We will need to dig into error logs to identify what is happening.  Can you please reproduce this problem on your side and let me know what day you make the call (If it is not today)?  I'll have the dev team dig into the logs for additional infromation.

Okay, I tried three times at:

Aug 5, 2015 17:45:00 Mountain Time (Calgary/Edmonton)
Aug 5, 2015 17:51:20 Mountain Time (Calgary/Edmonton)
Aug 5, 2015 17:54:05 Mountain Time (Calgary/Edmonton)

I don't get an error now, I get nothing at all in the response every time:

<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "" ></MethodAPI>

The file was called rocket.png, 576 bytes, that I'm adding to RecordId 276 in the Customer table if that helps.  The field is called IdCardPhoto. 

Please let me know what you see.

Bob

Any news?

Thanks,

Bob