Sage 50 2014 SData issues

Question

Hi I am having a bit of trouble with sdata. I have been able to see a schema using http://localhost:5493/sdata/accounts50/GCRM/-/$schema. When I try to view accounts etc, through something like the following localhost:5493/sdata/accounts50/GCRM/-/accounts('ACCOUNTCODE') I get an error errorResourceKindNotFoundUnable to locate the specified object 'accounts50/GCRM/-/accounts'

I have tried several variations of the url based on this resource http://sage.github.io/SData-2.0/

Am I missing I missing some configuration? I have base the url on the details provided by the Sage.SData.Service.Config.UI.exe utility. Any help is appreciated.

Answer 1

this is the one I tried should get you started

http://localhost:5493/sdata/accounts50/GCRM/-/tradingAccounts

if want to do a query you simple add this to the end ?select=name&count=3 and if you want use json just add this &format=json so your full string would read as http://localhost:5493/sdata/accounts50/GCRM/-/tradingAccounts?select=name&count=3&format=json hope this helps

Answer 2

I have been working on a laravel project that uses sData and whilst there appears to be no documentaion on end point I have compiled a list that can be used to gather data from sage accounts here is the list I have used.

sagecrmErp2008feeds

bankAccounts, commodities, commodityGroups, commodityIdentifiers, computePrice, computePriceSchema, contacts, contactGroups, financialPeriods, interactions, locations, operatingCompanies, Opportunities, prices, priceLists, pricingDocumentLine, projects, purchaseOrderDeliveries, purchaseOrderDeliveryLines, purchaseOrders, purchaseOrderLines, receipts, salesCredits, salesCreditLines, salesInvoices, salesInvoiceLines, salesOrderDeliveries, salesOrderDeliveryLines, salesOrders, salesOrderLines, salesPersons, salesQuotations, salesQuotationLines, taxCodes, tradingAccounts, tradingAccountSummaries, tradingActivities, unitsOfMeasure, unitsOfMeasureGroup,

sage2009feeds

emails, financialAccounts, notes, phoneNumbers, postalAddresses,

these should help you user835440