Method Community

 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?

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

Thanks,

Paul

I just tried it again.

 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

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

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

Want to give it a try?

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?

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

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")

 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?

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.

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.