• Replies 6 replies
  • Subscribers 339 subscribers
  • Views 22 views
  • Users 0 members are here
Related

Invoke GetAPIDiagnostics in a sproc?

Chris Jensen
$organization

Does anyone know of a way to invoke the Web API method GetAPIDiagnostics in a SQL stored procedure?


Thanks!


Parents
  • $organization

    That would be in the TXP_someprocedurenamehere procedures.  You can see the stored procedure name and parameters, but the source code lies within a compiled assembly.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Tuesday, August 17, 2010 5:17 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Invoke GetAPIDiagnostics in a sproc?

     

    Ryan Creps:

    This is what we use to invoke the Tessitura API for Order Email Confirmations in the client

    Hmm. Where is that done? WP_GET_ORDER_CONF_DATA?

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 8/17/2010 3:24:27 PM

    Yep, only way to invoke SOAP methods in a stored procedure would be to create a CLR procedure that referenced a compiled assembly.  This is what we use to invoke the Tessitura API for Order Email Confirmations in the client as well as allow the Tessitura Report Server to talk to the SQL Report Server for scheduled report requests using SSRS.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Hilgers
    Sent: Tuesday, August 17, 2010 4:21 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Invoke GetAPIDiagnostics in a sproc?

     

    I wasn’t able to through a stored procedure but I was able to call it through SSRS with an XML type data source in testing but I never went live with it.  I think you have to make a CLR function or something like that to do it as an sp.  But I’d love to hear I’m wrong.

     

    MH

    matt_hilgers@milwaukeeartspartners.org

    IM:  matt_hilgers

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Tuesday, August 17, 2010 3:01 PM
    To: Matt Hilgers
    Subject: [Tessitura Technical Forum] Invoke GetAPIDiagnostics in a sproc?

     

    Does anyone know of a way to invoke the Web API method GetAPIDiagnostics in a SQL stored procedure?


    Thanks!

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization in reply to Ryan Creps (Past Staff Member)

    Unknown said:
    That would be in the TXP_someprocedurenamehere procedures.  You can see the stored procedure name and parameters, but the source code lies within a compiled assembly.

    Ah, I see. Bummer. Those don't even really fit the definition of sprocs, do they?

    Thanks for the replies, guys.

Reply Children
  • $organization in reply to Chris Jensen

    A very old thread, but, to answer my own question:

    Declare @Object as Int;
Declare @ResponseText as Varchar(8000);

-- Code Snippet
Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'get',
	'https://[Your SOAPApi Server]/TessituraWebAPI/Tessitura.asmx/GetAPIDiagnostics', 
	'false'
Exec sp_OAMethod @Object, 'send'
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT

Select @ResponseText

Exec sp_OADestroy @Object