CRM APIs Errors

Steven Cinquegrana
Steven Cinquegrana
Ninth Anniversary Kudos 2 Name Dropper Participant
in SKY Developer General Discussions

I'm trying to check our SKYLib.NET code against the CRM API endpoints using cohort creds and am getting the following error. This is an example using the parameterless CRM Administration/Get Currency List endpoint; other endpoints are the same:

{
"type": "urn:blackbaud:general-translation-error",
"title": "One or more validation errors occurred.",
"status": 400,
"detail": "Error processing Infinity response: <Envelope>\\n <Body>\\n <GetRowsReply>\\n <StatusOK>false</StatusOK>\\n <StatusCode>500</StatusCode>\\n <StatusMessage>User 910fd81a-35b3-4f0f-a4a4-91f86bd8de1c does not exist.</StatusMessage>\\n <ErrorDetail>\\n <ServiceErrorCode>GeneralError</ServiceErrorCode>\\n <ServiceErrorCodeNumber>0</ServiceErrorCodeNumber>\\n <ErrorText>User 910fd81a-35b3-4f0f-a4a4-91f86bd8de1c does not exist.</ErrorText>\\n <ErrorDetails>Blackbaud.AppFx.Server.ServiceException: User 910fd81a-35b3-4f0f-a4a4-91f86bd8de1c does not exist. ---&gt; Blackbaud.AppFx.Server.ServiceException\\n at Blackbaud.AppFx.Server.AppUserInfo.LoadAppUserInfoForRunAs(RequestContext ctx, String&amp; runAs, Guid runAsUserID)\\n --- End of inner exception stack trace ---\\n at Blackbaud.AppFx.Server.AppUserInfo.LoadAppUserInfoForRunAs(RequestContext ctx, String&amp; runAs, Guid runAsUserID)\\n at Blackbaud.AppFx.Server.AppUserInfo.CheckRunAs(RequestContext ctx)\\n at Blackbaud.AppFx.Server.AppUserInfo..ctor(RequestContext ctx)\\n at Blackbaud.AppFx.Server.RequestContext.get_AppUserInfo()\\n at Blackbaud.AppFx.Server.RequestContext.VerifyValidApplicationUser()\\n at Blackbaud.AppFx.Server.AppService.BeginDispatchRequest(AsyncRequestProcessorBase processor, AsyncCallback callback, Object asyncState)</ErrorDetails>\\n <DataFormErrorCode>GeneralError</DataFormErrorCode>\\n <DataFormErrorCodeNumber>0</DataFormErrorCodeNumber>\\n <DataFormErrorInvalidFieldReason nil=\\"true\\" />\\n </ErrorDetail>\\n <TotalAvailableRows>0</TotalAvailableRows>\\n <TotalRowsInReply>0</TotalRowsInReply>\\n <Rows />\\n </GetRowsReply>\\n </Body>\\n</Envelope>",
"trace_id": "4ba3027f8be14249834bc6de6b22fad1",
"span_id": "05a0541886688e9e"
}

I'm guessing that there's an authorisation issue but could someone please confirm? I'm signed in and authorisation succeeded.

I'll try the Altru APIs and see if they're any different.

Thanks,

Steve Cinquegrana | CEO and Principal Developer | Protégé Solutions

Comments

  • Steven Cinquegrana
    Steven Cinquegrana
    Ninth Anniversary Kudos 2 Name Dropper Participant

    @Steven Cinquegrana Calling Altru Administration/List code table entries also produces a verbose error which appears to say that a stored procedure is missing ("Could not find stored procedure 'dbo.USP_ALL_GETLIST'.")

    {
    "type": "urn:blackbaud:general-translation-error",
    "title": "One or more validation errors occurred.",
    "status": 400,
    "detail": "One or more errors occurred. (Error in proxy call: <?xml version=\\"1.0\\" encoding=\\"utf-8\\"?><soap:Envelope xmlns:soap=\\"http://schemas.xmlsoap.org/soap/envelope/\\" xmlns:xsi=\\"http://www.w3.org/2001/XMLSchema-instance\\" xmlns:xsd=\\"http://www.w3.org/2001/XMLSchema\\"><soap:Header><ResponseErrorHeader xmlns=\\"Blackbaud.AppFx.WebService.API.1\\"><ErrorCode>GeneralError</ErrorCode><ErrorText>Could not find stored procedure 'dbo.USP_ALL_GETLIST'.</ErrorText><ExceptionDetails>System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'dbo.USP_ALL_GETLIST'.\\r\\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\\r\\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\\r\\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)\\r\\n at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\\r\\n at System.Data.SqlClient.SqlDataReader.get_MetaData()\\r\\n at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\\r\\n at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\\r\\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)\\r\\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\\r\\n at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\\r\\n at System.Data.SqlClient.SqlCommand.ExecuteReader()\\r\\n at Blackbaud.AppFx.Server.CodeTableEntryGetListProcessor.ProcessRequest()\\r\\n at Blackbaud.AppFx.Server.RequestProcessor`2.GetReply()\\r\\n at Blackbaud.AppFx.Server.AppService.DispatchSyncRequest(RequestProcessorBase processor)\\r\\n at Blackbaud.AppFx.Server.AppService.DispatchRequest(RequestProcessorBase processor)\\r\\nClientConnectionId:64896b55-b1c6-425d-9d47-7b8d39bdabcb\\r\\nError Number:2812,State:62,Class:16</ExceptionDetails><RequestProcessorName>Blackbaud.AppFx.Server.CodeTableEntryGetListProcessor</RequestProcessorName></ResponseErrorHeader></soap:Header><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>Server was unable to process request. ---&gt; Could not find stored procedure 'dbo.USP_ALL_GETLIST'.</faultstring><detail /></soap:Fault></soap:Body></soap:Envelope>)",
    "trace_id": "119b3ea78d9d400fb397d5238475a719",
    "span_id": "18bd0ea5b26da6d6"
    }

  • David Hendershot
    David Hendershot
    Eighth Anniversary Name Dropper Participant Facilitator 1

    @Steven Cinquegrana have you been added to CRM and Altru? What org/env are you authorizing against?

  • Steven Cinquegrana
    Steven Cinquegrana
    Ninth Anniversary Kudos 2 Name Dropper Participant

    @David Hendershot Thanks for your reply. I'm authorising against the cohort enviro. I would have thought that that enviro would already have the CRM and Altru products/APIs added.

  • David Hendershot
    David Hendershot
    Eighth Anniversary Name Dropper Participant Facilitator 1

    @Steven Cinquegrana Blackbaud CRM and Altru have their own internal user permissions. So, in addition to needing access to the cohort env, your BBID user needs to be added to those environments as well. If you send an access request to skyapi@blackbaud.com, we should be able to get you set up!

  • Jacky Schuler
    Jacky Schuler
    Third Anniversary Kudos 1 Name Dropper Facilitator 1

    @Steven Cinquegrana I am having the same issue with Altru, which is basically BBCRM Lite, and I have never been able to use the API, even via “Try Me” in the API documentation. I have a support ticket open and the rep has told me that they are still working on the issue. When I get an update I will share it here.

    Meanwhile, if anybody else has solved this issue, I would love to know as I am getting antsy about the API! It have checked multiple times that it is not a permissions issue or bad request.

Categories