Method:API Q&A

Re: MethodAPI v1.1 update - ability to add new tables and fields

Method_Paul — Tue, 20 Jan 2009 21:29:30 GMT

Hey Matt,

We checked into it further using the reserved word "Day", and have put more validation in. We have tried using the latest API on it, and everything seems good now, and you properly get back the warning about the reserved word, and it causes no havoc this time.

Do you want to check your database on your end and ensure all is fixed up?

Paul

Re: MethodAPI v1.1 update - ability to add new tables and fields

Matt — Mon, 19 Jan 2009 22:02:24 GMT

I was able to reproduce this error again. Here is what I did:

I created a new table

I created a new field in that table (however, unbeknownst to me the field name that I tried to use is a reserved word and therefore was not able to be added.

I then tried to insert records into the new table (obviously not going to work because the field could not be added to it). When I attempted to insert the records I got the error "It does not appear the field Day exists in the table."No problem here.

Now when the program tried to continue adding fields to the customer table I got the following error each time:

Failure. The API could not validate your log in. Please make sure you have entered the correct Company Account, User and Password, and that each are spelt correctly. Also, ensure that this User has been configured for Method API access by going to Customize > Users, editing the User, and ensuring that there is a check in the 'Is Allowed to Connect via MethodAPI' checkbox.

Hope that helps you to be able to track the issue down.

Re: MethodAPI v1.1 update - ability to add new tables and fields

Matt — Mon, 12 Jan 2009 22:49:01 GMT

As far as the random fields......they are not fields from another table either. Their names are very similar to the names of some of the fields I added through the API.

Re: MethodAPI v1.1 update - ability to add new tables and fields

Method_Paul — Mon, 12 Jan 2009 17:34:28 GMT

Hmmm....hard to say what the original problem was. We were getting a few error messages from the API, after it was first released, which we were quickly able to solve. Not sure if those errors had anything to do with you, so we'll keep an eye on it.

For the customer screen, yes, it is confusing. Since the Customer is actually a "view" of the overall Entity table which contains all Customers, Vendors and Employees, you see fields under Customize > Tables for "Customer" which actually belong to "Employee". We are aware of this being confusing, and it's on our list of things to improve.

The other table like this is "Item" where all the "ItemService", "ItemInventory", etc. show all fields in the Item table, not just those that pertain to their type.

Re: MethodAPI v1.1 update - ability to add new tables and fields

Matt — Sat, 10 Jan 2009 02:19:15 GMT

Paul,

I Deleted all the fields nad tables I created through the API and tried it again, now I'm not having any problems. Got me?

On a related note (I think, because I didn't notice it until after using the create table and create field calls)....

When I go to customize the customerlist screen, there are fields available to put on the screen that aren't in the customer table. Any reason that could be? If you think I'm crazy and wanna have a look-see, email me at matt@apexservices.net and I'll give you my name and password.

Re: MethodAPI v1.1 update - ability to add new tables and fields

Method_Paul — Fri, 09 Jan 2009 21:13:23 GMT

Hey Matt -

Both Peter and I tried it here and couldn't duplicate the problem. Everything worked fine on our end with no messages.

Was it a certain table you were having problems with, or all tables?

Does it happen every time?

Paul

Re: MethodAPI v1.1 update - ability to add new tables and fields

Matt — Thu, 08 Jan 2009 22:55:09 GMT

Thanks for adding this!

Just FYI when I do the createField call I get an error that says "Failure. The API could not validate your log in. Please make sure you have entered the correct Company Account, User and Password, and that each are spelt correctly. Also, ensure that this User has been configured for Method API access by going to Customize > Users, editing the User, and ensuring that there is a check in the 'Is Allowed to Connect via MethodAPI' checkbox."

I only get this error with createField and although I get the error message the field DOES get added to Method

Re: MethodAPI v1.1 update - ability to add new tables and fields

meninkilts — Thu, 08 Jan 2009 01:14:10 GMT

Yes Paul you guys rock!!! Cheers Brent

MethodAPI v1.1 update - ability to add new tables and fields

Method_Paul — Wed, 07 Jan 2009 22:22:38 GMT

Hey developers,

I wanted to let everyone know that we made two API calls available today: MethodAPICreateTable and MethodAPICreateField.

These simulate what you can do directly in the Method web app, under Customize > Tables / Fields. So in other words you can create your own tables, as well as add fields to existing tables. Fields can be Text, Decimal, Integer, DateTime, Money, YesNo, Picture.....and yes, of course, Dropdown.

Here is the updated API documentation:

http://www.methodintegration.com/documentation/MethodAPIv1_1_Documentation.pdf

Paul