Method:API Q&A

Re: CreateField Error message

Matt — Thu, 29 Jan 2009 17:27:12 GMT

I changed the name of the field I was trying to add and it worked correctly. I also tried adding the new field a second time and received a proper error message about it not being unique. So it seems to be working properly except when I try to add the field using the origional name.

Re: CreateField Error message

Matt — Wed, 28 Jan 2009 23:51:40 GMT

No, I'm still getting the same error message as before.

I checked in the Customer table in Method and the field that I am trying to add is not in there.

Re: CreateField Error message

Method_Paul — Wed, 28 Jan 2009 23:17:13 GMT

We're getting a message that the field you are creating already exists. Just made a couple changes on the backend to put that into the response message. Are you getting a more informative response if you try again now?

Re: CreateField Error message

Matt — Wed, 28 Jan 2009 22:41:15 GMT

It appears I spoke too soon. (Actually I was looking in the completely wrong place when I was testing it out).

I tried to create a dropdown field in the customer table and I still get the "An error has occurred. An email has been sent to Method staff. If this problem persists, please contact the Method Team at method@alocet.com."

Not sure if it is related or not, but the table I am trying to link the dropdown to is the same one that you referenced earlier (trying to add a record that already exsists such as "Friday")

Re: CreateField Error message

Method_Paul — Wed, 28 Jan 2009 22:02:25 GMT

Yes, that should be the message you get in both the MethodAPIUpdate and the MethodAPIInsert.

Re: CreateField Error message

Matt — Wed, 28 Jan 2009 21:09:45 GMT

It appears to work now. Now I get "This insertion will violate a requirement that the record in the destination table must be unique."

I also noticed that some of the other messages about a record not be unique have been changed to the same new message. Is this going to now be the standard message?

Re: CreateField Error message

Method_Paul — Wed, 28 Jan 2009 19:57:41 GMT

Updates are up there now (we were about to do an update anyway).

Want to give it a try?

Re: CreateField Error message

Matt — Wed, 28 Jan 2009 18:59:18 GMT

Thanks Paul. Can you please let me know when you have that updated, so I can change my code to handle the duplicates.

Re: CreateField Error message

Method_Paul — Wed, 28 Jan 2009 18:51:26 GMT

Thanks Matt.

Looks like the problem was that you were inserting records like "Friday" into a table that already had "Friday". Since that table had the field marked as unique, it caused a unique index violation.

So there's you reason.

We'll put more info on the returned message so that you actually get this in the response next time.

Paul

Re: CreateField Error message

Matt — Wed, 28 Jan 2009 18:44:49 GMT

I just tried it again.

Re: CreateField Error message

Method_Paul — Mon, 26 Jan 2009 23:11:29 GMT

Matt - can you try doing it again. Let us know when you do, and we'll search for the error message.

Thanks,

Paul

CreateField Error message

Matt — Thu, 22 Jan 2009 18:12:05 GMT

I am trying to create a dropdown field in the customer table through the API. When i run the code I get the error message "An error has occurred. An email has been sent to Method staff. If this problem persists, please contact the Method Team at method@alocet.com." How do I find out what the actual error is so I can fix it?