Phocas
Contributing User
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: EXO Demo database SQL backup
Thankyou Will_H I don't have a customer that I can ask at the moment - I build Solutions - generally for all MYOB EXO users of Phocas. Phocas has some partner relationship with MYOB that I assume gives us some pathway to ask for help directly. Is this possible I did manage to find the Old Demo sets I mentioned previously so I can continue to develop our integration. I am interested in the Version Differences you mention here. So that I can document the version compatibility for our integrations many thanks53Views0likes0CommentsHigh Water Mark - suggestions for Incremental extraction of Sales Invoice Data (lastModified does not work)
Hi I am looking to incrementally load transactions from {{company_file_uri}}/{{company_file_id}}/Sale/Invoice/Item?$filter=Date ge datetime'{{HWMvalue}}$orderby=LastModified the High water Mark - {{HWMValue}} maximum value of LastModified is retrieved from the already extracted data - Having some challenges. - A fair chunk of the available data has a LastModified date of 1970-01-01 . I assume this is a placeholder for "null" this means I cant use lastModified to fetch conservative amounts of data from the API I have attempted to use the sales invoice "Date" field as a high water mark (While this Date not ideal to use for loading incrementally at least , hopefully, it should allow me to load in historical data) - there are quite a few rows I'm expecting - 35099 Headers and 497875 Lines. Is there a best practice strategy for 1. Bulk fetching historical data 2. Incremental fetching Sales InvoicesSolved1.5KViews0likes2CommentsRe: EXO Demo Data
Thankyou for the prompt reply ! Yes that Info schema link is very handy - One of the better documented Databases! I am interested in integrating with EXO Business. We do this currently via sql queries where the customer has an on prem instance of EXO data. My aim was to have access to a sandbox account with existing demo data. To test and develop and improve our integration. Or a copy (sql BAK) of demo database so that I can test our integration tool locally. Additionally I understand there is an option to use an API. I would like to investigate this - again if there is a sandbox demo cloud database I can target this would be awesome Many Thanks1.3KViews0likes1Comment