Sage / SData-2.0

Contains documents pertaining to the SData 2.0 developments
33 stars 10 forks source link

Unable to locate the specified object 'accounts50/GCRM/-' When Connecting to SDATA URL #132

Closed joebi3 closed 5 years ago

joebi3 commented 5 years ago

Hi, When I try to connect to the sdata url generated by sage in the Internet Options > Details Window for Sage 50 Accounts I get the following XML error

`

error ResourceKindNotFound Unable to locate the specified object 'accounts50/GCRM/-' ` The URL being shown in the client window is: Sage 50 Accounts supports GCRM integration. [REDACTED]: http://sage-server:5495/sdata/accounts50/GCRM/{0020404B-E2C9-41EB-9092-35BB175BF292} Current Sage 50 Version: 25.1.128.0 Clean install on a brand new windows 2012 server (due to hardware issues on the previous server). We have never tried to connect via SData before. Any suggestions?
asterix187 commented 5 years ago

If you add /$schema to the end does anything get shown?


From: joebi3 notifications@github.com Sent: Tuesday, May 21, 2019 10:24:58 AM To: Sage/SData-2.0 Cc: Subscribed Subject: [Sage/SData-2.0] Unable to locate the specified object 'accounts50/GCRM/-' When Connecting to SDATA URL (#132)

Hi, When I try to connect to the sdata url generated by sage in the Internet Options > Details Window for Sage 50 Accounts I get the following XML error

error ResourceKindNotFound Unable to locate the specified object 'accounts50/GCRM/-'

The URL being shown in the client window is: Sage 50 Accounts supports GCRM integration. [REDACTED]: http://sage-server:5495/sdata/accounts50/GCRM/{0020404B-E2C9-41EB-9092-35BB175BF292}http://sage-server:5495/sdata/accounts50/GCRM/%7B0020404B-E2C9-41EB-9092-35BB175BF292%7D

Current Sage 50 Version: 25.1.128.0 Clean install on a brand new windows 2012 server (due to hardware issues on the previous server). We have never tried to connect via SData before.

Any suggestions?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/Sage/SData-2.0/issues/132?email_source=notifications&email_token=ABYBOXLINKHQHSPJ5TTKRCLPWO5WVA5CNFSM4HOJBQ6KYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4GU5GZCQ, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABYBOXKF74DMBZYBCH56YB3PWO5WVANCNFSM4HOJBQ6A.

joebi3 commented 5 years ago

Yeah, I get what looks to be the XML schema for our data, after being prompted for my sage credentials. I can paste it here if needed?

asterix187 commented 5 years ago

Hi, ok try /tradingaccounts?count=1 at the end instead. Does it return as customer record?

Qmulus Solutions | The UK&I No.1 Sage CRM Business Partner Sage CRM Partner of the Year 2014 | 2015 | 2016 | 2017 | 2018

Telephone: + 44 (0)845 450 3991 Web: www.qmulus-solutions.comhttp://www.qmulus-solutions.com/

From: joebi3 notifications@github.com Reply-To: "Sage/SData-2.0" reply@reply.github.com Date: Tuesday, 21 May 2019 at 10:42 To: "Sage/SData-2.0" SData-2.0@noreply.github.com Cc: Daniel Lewis daniel.lewis@qmulus-solutions.com, Comment comment@noreply.github.com Subject: Re: [Sage/SData-2.0] Unable to locate the specified object 'accounts50/GCRM/-' When Connecting to SDATA URL (#132)

Yeah, I get what looks to be the XML schema for our data, after being prompted for my sage credentials. I can paste it here if needed?

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/Sage/SData-2.0/issues/132?email_source=notifications&email_token=ABYBOXKGTXN4YXRI2EYWC23PWO7YLA5CNFSM4HOJBQ6KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODV3LN7Q#issuecomment-494319358, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABYBOXJWQQZPIIRWLAY53FDPWO7YLANCNFSM4HOJBQ6A.

joebi3 commented 5 years ago

It returns an XML doc that says it's from my company data, but there are 0 records:

`<?xml version="1.0" encoding="utf-8"?>

``` Provides a feed containing tradingAccount details Sage Accounts 50 | tradingAccount - [COMPANY NAME REDACTED] 0 1 10 ` ``` Thanks,
darroncockram commented 5 years ago

The 404 error from the original endpoint you posted would be expected as you have not requested a valid resource kind. With the /tradingAccounts endpoint returning 0 records this may also be correct, do you have any customers or suppliers in the dataset you are connecting to? If you try the /taxCodes endpoint this should return data regardless even if you are connecting to an empty dataset.

Hope that helps.