I am trying to interface with SBM using web services. I can query tables fine. I want to be able to query the items that are in "internal DBs" (I think they are called). Items like selection lists. How do I get what are valid display names and IDs for items in something like a selection list?
One possible solution might be (unless you're using On-Demand) to create a URL context AppScript that your program can access. Pass tableID param, list of fields you want returned and maybe a "where" clause to the AppScript in the URL. The AppScript would run the query, format the results and write it to the HTTP output stream (I suggest using JSON format) which your program would then get and parse.