Method Community

BartH, Can you tell me what tables and field you are using?  Is it an existing table and field or a custom one?  Which version are you using, the December or January version?  If you were using the December version, try using the January version and see if the issue persists. - Adam

I am using  Azure ADF services   under Rest serverce activities :      i want to get last month till today date record , how do i put into URL endpoint :  @{concat('https://rest.method.me/api/v1/tables/SalesOrder?filter=TxnDate ge ''', formatDateTime(utcNow(), 'yyyy-MM-dd'), ...

I've been trying to query journal entries from QuickBooks Online using the Method API. I've created a sort of generic function to query the table in Google Apps Script and copy the data to a sheet. This code works fine for other tables (like Account, Invoice, etc), but for some reason doesn't work for either JournalEntry or ...

Hi all,  I would like to filter and fetch the record based on my current day ,  for example : https://rest.method.me/api/v1/tables/SalesOrder/?filter=TxnDate eq '2024-05-09 13:00:00 -05:00'   here instead of static date   I want to dynamically filter and retrieve records based on the current day. For ...

So I'm here on behalf of a non-profit I work with that uses Online Giving for their credit card donations. They've been fairly happy and dont' really want to migrate away but are hoping to integrate with Method since they've only recently switched here. Online Giving (the company) is willing to look at an integration however I ...

I am having an issue inserting data into one of my tables via the API.  The CoursePayments table is telling me when I try to insert data that the "Table does not support add."  When the call happens it is working about half the time, which is concerning since the data looks almost identical between calls to insert the ...

Hello,  Could you help me to understand the difference in the Customer table and the Contact table?  I am adding some fields in and I have placed them in my Customer table but when trying to filter searches on them I notices that the default customer search and display grid is actually pulling from my Contacts table.  I am ...

We sent a mailer as part of a campaign just before we started using Method. In importing these leads into Method, I originally hoped (and assumed) we could just include the name of a campaign (already created) along with other fields while doing the lead import, and do it all at once. I learned that this is not possible, since Contacts and ...

We are working through the quirks of setting up report templates and other things related to tables and while we are usually able to figure things out, we frequently have questions about a particular field or table. For example, "is this the right field to use? It's displaying empty - what is it supposed to contain?", etc. So far ...

Update: I figured it out. The QuickBooks_Estimate screen is based on the Estimate table yet One the EstimateLine grid is based on the EstimateLine table. If I add a new grid to a copy of the QuickBooks_Estimate screen I have the option to attach a table to the grid. The dropdown allows me to select the Estimate, DocumentLibraryLink and ...