Oracle Apex - Rest data source parameters

Question

I'm using oracle apex version 23.2.

I have a rest data source of type = Simple HTTP that i'm trying to filter by a query parameter named "fieldvalue".

When I input my entire url into the url path prefix like so api/v2/search.json?query=type:ticket fieldvalue:12345678 and test the operation, it appropriately returns the result set i'm looking for.

When I remove fieldvalue:12345678 from the url prefix and try to turn it into a parameter, I can never get the correct results. I've tried using it as a url pattern, url query string, http header, and a request body.

The way the query string documentation reads, I should be able to create two variables and append them to my path. So I shortened my path to just api/v2/search.json. I created two variables, both of type query string. One of which is static with name = query and default value = type:ticket. The other is name = fieldvalue and the default value = 12345678 with the data type set to numeric and required set to on. When I test this operation it just returns all of the tickets and ignores my parameters completely.

The documentation makes it seem so simple and straight forward. Does anyone know what i'm missing here?

Answer 1

For a REST Data Source, everything after the question mark is a Query String parameter, and in your case, this is one parameter named query with a value of type:ticket fieldvalue:12345678. However, when you create the REST Source, the wizard will be a bit confused about the colons in your parameter value - it thinks that these indicate additional parameters. So you might create the REST Source a bit different ...

• On the first wizard step, only provide the URL until the question mark, i.e. api/v2/search.json.
• Advance to the Advanced wizard step
• then configure one parameter
  • Type Query String
  • Name query
  • Value type:ticket fieldvalue:12345678