Marcus_Wolfe
Experienced Cover User
Joined 12 years ago
User Profile
User Widgets
Contributions
Re: LastModified and RowVersion don't change when Jobs and Accounts change
Hi Hannah, thanks for the reply. The original post requested a recommendation for an improvement to my process so I suppose I'll assume that none is possible. This counts as a solution too, in fact it's the same as the solution to literally every other question I've asked about this API. In my opinion, the purpose of last modified dates and row versions is to reduce the size of data transfers and minimise handling for returned data. It is a poor implementation if I can't use them to maintain extremely basic data such as Job IsActive or Account CurrentBalance, and it causes my software to be much more slow, expensive and error prone than it should be. Further, I can't imagine an actual use for the LastModified field on the Accounts table if it can't be used to maintain current balance. Regards, Marcus Wolfe1.2KViews1like0CommentsLastModified and RowVersion don't change when Jobs and Accounts change
Can anyone recommend an approach to update a table of Jobs and Accounts, particularly the fields Job IsActive and Account CurrentBalance, without having to request Every Job and Every Account every time? I tried to request only jobs and accounts which had a recent "LastModified" date, but have found that making a job Inactive does not constitute a Modification. Neither does a change in an Account CurrentBalance. Neither of these changes changes the LastModified date, it also doesn't create a new RowVersion for the records. So I don't seem to be able to use RowVersion to compare two copies of a record to identify records that need to be updated in my table. My current solution is to request All the jobs and All the accounts from the AccountRight file, then update All the fields in All the records in both tables. Exactly the same as what I would do if there were no such thing as RowVersion or LastModified field. Is that the best I can do?Solved1.3KViews0likes2CommentsRe: API Endpoints for Foreign Currency
Hi Everyone, I'm replying to my own post, I heard back from the myob developers and apparently it's been decided that there will be API access to foreign currency transactions but there's no plan or indication of when. My advice is, just forget it, then be pleasantly surprised when it happens. You will be a lot older by then, obviously.1.2KViews0likes0CommentsRe: x-myobapi-cftoken
The Access Token that you use to make http requests to MYOB is associated with an "online file user" with a my.myob account. If that my.myob account is associated with a Company File User (in MYOB, Manage Users, select "this user will sign on with a my.MYOB account") you don't need the x-myobapi-cftoken. It's the same as when you are using AccountRight Live, if the company file user is linked to your my.myob account you log in through my.myob and don't see the Company File User login screen. When the my.myob account that's getting the Access Token is linked to a Company File User you can just leave the x-myobapi-cftoken header out of your http request message. The Access Token authenticates the Company File User through the Online File User.1.7KViews1like0CommentsAPI Endpoints for Foreign Currency
Hi, can I please have an update on the availability of endpoints for Foreign Currency details in the API? According to the MYOB page on working with foreign currencies, FAQ, this is due in Q3 2019, which finished yesterday. Is there a page anywhere that provides any details of what endpoints and data will be made available? There is a page "Updates coming to AccountRight Live" with a link to http://developer.myob.com/api/accountright/multi-currency but that page doesn't exist. Alternatively can you please tell me whether I will be able to create a Spend Money Transaction through the API, in a foreign currency, and either a) set a custom exchange rate and/or b) read both the local and foreign currency transaction values after the transaction is created, so I can make journal transactions to balance both currencies? (The usage is: we spend money in NZ using Australian credit cards and create Spend Money Transactions through the API. We need to make both currencies in the transactions exact, to reconcile the credit card balances and report the NZ expense and GST.)Solved1.3KViews0likes1Comment