API Get Keywords by Performance ID

When I wanted that data, I had to build my own using a "Local Table". (/Custom in REST).  Just remember that your view needs to pull in inherited values from higher production elements.

Previous iterations of the site I was working on had literally done filter searches for each performance keyword being used and then spooled through the results to find out if the performance in question was one of them!  Blech.

Oh, forgot.  For REST you'll have to use Custom/Execute and a stored procedure.  The REST API, alas, doesn't support views.

Ah, that's a shame.

Theoretically.. could you just build a custom prodecure and run that on the Custom call rather than building a table?  Or does the API require a table?

Cheers

Yes, that's what you will have to do: create a stored procedure and access it with Custom/Execute.

You can use views with the SOAP API, but I think it's best to build anything new in REST where possible.

Yes, that's what you will have to do: create a stored procedure and access it with Custom/Execute.

You can use views with the SOAP API, but I think it's best to build anything new in REST where possible.

Great!

Do you have the link to the documentation for setting up a custom stored procedure for use with the API (SOAP or REST)?  I vaguely remember having to register the procedure but I'm having some trouble calling it through REST.

Any resrouces are much appriciated, thank ya.

Documentation for REST Custom/Execute is spotty, so I hope this will cover it:

Yeah, thankfully I have access to the developer site.  This helps, I wish I could remember where I saw the documentation for your Steps 1-3, as it went into a little more detail how to structure those things.  But, like you said, the API documentation seems to kind of be all over the place.

I haven't developed a way to issue POST requests through my current iteration of code (only GET is working at the moment), and I'm a little confused on how to format the "Body" content in JSON for the request.

I appriciate the help, Gawain.

Because the Request is not called in the URI, would this be an example of the correct URI call to invoke a POST?

BTW, I am using some of the code from the PHP API Wrapper.

$args = array(
	'request_method'	=>	'POST',
	'ProcedureId'		=>	'56',
	'Parameters'		=>	'@sessionKey=123456&@perf_id=5994'
);

$var = tessitura_rest_call('Custom/Execute', $args);

Edit:

Got the call working in Postman!

However, something wrong on my PHP code, getting a error in response.

Unexpected end of file.

I'm thinking something wrong with the JSON encoding in curl, will post an update.

That was my next question: "how you were going to consume it?"  You might look into cURL if PHP is your thing, but perhaps someone from the network can help you with this API Wrapper thing.

I haven't done any PHP in ages, but if I'm reading the first few lines correctly it's actually setting the request method to GET regardless of what you pass in.

Got the call working in Postman!

Ah, good.  I'm afraid my ability to help you likely ends here.