Thanks Charith, it works perfectly !!
Yes, we have Aurena installed.
Hello Mathias,We want to use the API in a Webservice, not use a SQL command in it. We will use php to invoke the API with curl command. In other words we want to do something like this $curl = curl_init(); curl_setopt_array($curl, array( CURLOPT_URL => 'https://xxxx.ifs.cloud:48080/int/ifsapplications/projection/v1/DocumentRevisionsHandling.svc/DocIssueSet?%24filter=contains(Title%2C%27TEST%27)%20and%20contains(Info%2C%27Test%20test%27)%20and%20Objstate%20eq%20IfsApp.DocumentRevisionsHandling.DocIssueState%27Released%27%20and%20DtObsolete%20eq%20null', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'GET', CURLOPT_HTTPHEADER => array( 'Authorization: Basic xxxxx=' ),));$response = curl_exec($curl);curl_close($curl);echo $response; and not something like “select * from … whrere ...”Maybe in
Hello Mathias,Well, this was the initial question: which API (if exists) do I have to use for downloading a document from the database ?
Hello Mathias,We’re on IEE but we want to use the API instead of SQL commands.
Hi @WyrDavidB,No, this is only an example, but now I found it !!Fndrr_Client_Profile_Value
Hello @Marcel.Ausan,Thank you very much.Yes it was not clear, I’m searching for a view name or an API to invoke to obtain those field.Thanks.
HI @luca.puccini Starting from LU name: dictionary_sys_tab, next view_name: dictionary_sys_view_tab(relation lu_name - lu_name) and ending with user_tab_columns(relation view_name - table_name). I suppose it helps. Hello @knepiosko Unfortunately I don’t have access to the tables, only to the views. Apart from that (it is possible to search which views depends on the table and then look at them) I discovered two usefull views that can help me. One shows the key of the view and the other shows all the columns of the view. With these two I can create a dynamic sql command that can retrieve the specific row in the view.Now my problem is to retrieve which columns are put on the screen of the specific user, in other words my first question. Is it possible to know where is stored that specific data ?Thanks !!
Hello @dsj Thanks for your question.Yes I’m interested in retrieving both the data, starting from the Object relations tab. I mean something like the following.select * from &AO.some_view where some_column_name=’’frmInventory_Part_Ext” ( or some_column_name like “frmInventory_Part_Ext%”)to collect all the names of the column that are visible on the screen, like the followingecmbPartNo,dfsDescription,dfsPartDescriptionInUse, and so on.Then, with these names, retrieve also the value of them.Thanks !!
The User has a Default Company and a Default Site. The Company and the Site are not new and other users are working good. It is a sort of mistery.
Hi @luca.puccini, In the custom menu configuration, under quick report parameters , specify the source key name and destination key name in CAPITALS. BR, Bhagya It remains exactly the same
Yes, it is! :) Ok, but how ?The SQL isas you suggested, but the window still appear
In other words, is it possible to avoid this window ?
Hello Navinth,What do you exactly mean with “ using a public get method of one of the Site related APIs or as a SELECT statement “ ?This is my Custom Field :
Custom Fields window → Search CustomerOrderLine LU Go to Approved Details views line (highlighted below) Note that SOURCE_LINE_SHIPMENT_ALT logical is approves state. RMB → Disapproved This work around will resolve your error. -Kelum Hello Kelum,it works now.Could you please give me an explanation of that ?Thanks.
Could you please tell me what might be the issue as we are also facing the same issue..While trying to send SMS to API we are getting the same error The remote server returned an error: (403) Forbidden. Hello,The first thing to do is to enable the API by AURENA. Then check if the server that you’re using to access the API can resolve the name of the server.This was my trobleshooting.Hope this helps.
Hello,The problem was in the DNS configuration of the server that we were using for accessing the api. Now it is working !!Thanks to everybody who made suggestions.
Hi All, Check whether the below post is helpful for this discussion. Hello,Yes, I saw that but the documentation is referring for accessing an Intranet server from the Internet, we’re looking at accessing OnCloud from Intranet.Thanks anyway !!!
Hello,Aurena:Postman: PHP program:(1) This part is the declaration of the API that we want to use (the address is not visible) The variable $ask0 is the basic address, $ask2 is the query for obtaining the top 25 Part Numbers that start with 'RM1A' (same as Postman)(2) This part is the initialization of the curl properties. The password is not visible.(3) This is the real execution of the API. If there is an error, it is echoing the error, otherwise it is showing the results.Thanks.
To solve this issue just add a rule into the http response header.Access-Control-Allow-Origin *Note that, instead of the * that means everybody, you can add a list of knowed url.
I have just solved it!You have to insert a new rule into the HTTP Response header: Access-Control-Allow-Origin *. Please note that, instead of using the * that means everyone, you can specify a list of knowed url.
Hello, here is the code. I hid the url and the authentication.<?phpini_set('display_errors', 1);error_reporting(E_ALL);$curl = curl_init();curl_setopt_array($curl, array( CURLOPT_URL => "https://xxxxx.ifs.cloud:48080/int/ifsapplications/projection/v1/PartHandling.svc/PartCatalogSet(PartNo='LUCA')", CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'GET', CURLOPT_HTTPHEADER => array( 'Content-Type:application/json', 'Authorization: Basic xxxxx==')));$response = curl_exec($curl);if($response === false){ echo 'Curl error: ' . curl_error($curl);} else { print_r($response);}curl_close($curl);?>Thanks.
There are two ways you can accomplish this. You can use an Event tied to an Event Action in UP8. Event Actions allow you to configure REST calls. Custom Menus do not. Therefore, you can also use the standard API directly in a custom menu using a PLSQL block. The script would look a little something like this: declare url_ Varchar2(500) := 'YOUR URL HERE'; text_ Varchar2(200) := 'YOUR JSON PAYLOAD HERE'; content_ Varchar2(30000); rest_sender_ Varchar2(2000) := 'REST_SENDER1'; end_point_ Varchar2(32000) := 'YOUR ENDPOINT HERE'; auth_method_ varchar2(2000) := 'Basic'; http_method_ Varchar2(50) := 'POST'; query_params_ Varchar2(32000); header_params_ Varchar2(32000); login_info_ Varchar2(32000) := 'Authorization=Basic YOUR BASE64 ENCODED KEY HERE'; rest_message_ clob; url_params_ varchar2(32000); blob_info_ Varchar2(32000); Begin rest_message_ := '{ "text": "'|| text_ || '"}'; command_sys.Send_Rest_Message ( rest_message_ , end_point_ ,
Andre, Here are some answers to your questions 1.Specific: Which level of OData does IFS v10 support? OData V4 2.General: Where does one find this kind of (deeper specification) ducumentation? There is an academy course here that might help? https://www.ifs.com/corp/resources-old/2019/04/04/ds10f1aud/ Regards, Antony Hello,The link is not working.Could you please give a new link ?Thanks.Luca
Hello William,I did not know about this function, but it is working good, thanks.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
