Hi,
After searching through the forums, I couldn't find a reliable answer to this question. I am trying to find an API call (or series of calls), be it SOAP or REST, which returns the Keywords assigned to a Performance when given a performance ID.
I know the REST API does not have full parity with the SOAP API currently, but I am comfortable using an intermediary solution in the meantime. I am also aware there are a few calls which allow for a Keyword Filter, but that is not the solution, unless it involves using Keywords as the base controller for displaying performances, which doesn't sound very ingegrated or reasonable.
Any suggestions are welcome.
Thanks!
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.
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: