Hi all,
I thought this one shouldn't too hard, but sofar I can't seem to get it right, so now I'm suffering from Parameter Issues.
So I thought it would be better to go to the APEX Forum again instead of a psychiatrist.
My plan still is to create an interactive report on a REST Data Source and be able to do searches on invoicenumbers through GET requests.
The REST Data Source works perfectly from the database using apex_rest_service.
I'm trying to understand what needs to be done to get it to work from APEX.
issue I)
Here's the URL, pretty simple, an invoicenumber is needed/mandatory for the GET request to succeed.
( BUT: Not sure if it should be :invoiceNumber or {invoiceNumber})
Issue II)
Apparently we can have ‘ Operations Parameters’ and ‘[REST Data Source global?] Parameters’, but somehow I managed to end up with both of them. Issue II: which one is the right one? ¿And why are there 2 kinds of parameters?
issue III )
IR region settings.
I understand now that I have 2 parameters, one for the GET request only and another for all requests.
But I do not understand why. I would have expected some kind of error message? And how do I connect one of them to the search item?
Issue IV)
I mean the search item that comes with the Interactive Report functionality.
So, just put in an invoicenumber and hit enter or click go, will there automagically be a GET request fired?
I've searched and read (and learned) a lot regarding this, but I did not find a similar question.
Also there's not much documentation regarding REST DATA Source parameters and their varieties and when to use which one and so on.
But if I've failed to find an article or similar problem description that has all the answers: please let me know.
Especially regarding how parameters work when you use REST Data Source.
Or could it be that what I want to do is impossible? That I would need to write my own custom code and don't use an Interactive Report page but create a page that uses apex_web_service?
I hope I phrased my question in an understandable way. If not: just let me know.
Thanks in advance for any help/tips/pointers!
Regards,
Hoek