Invoke GetAPIDiagnostics in a sproc?

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


Thanks!


Parents
  • 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!

Reply
  • 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!

Children
No Data