For me, a configuration in "Supervisor - Access Setup" was missing. Now it works.
I have also discovered the same problem. With 21R1 it worked if you put "ifsinfo." in prefix of the viewname. With 23R1 it does not work for me.
I also get the error message as soon as I try to enter several times directly one after the other. Even if they are my own. Only the first time is registered. After that I get the message{"error":{"code":"DATABASE_ERROR","message":"Database error occurred. Contact administrator.","details":[{"code":20105,"message":"ORA-20105: AccessAttribute.NO_ACC_TO_EMP_MOD: Insufficient access rights. You cannot modify Time Card data for the employee 10000."}]}}Our time terminals provide the data as CSV files. I would like to transfer them using the REST API. Or are there better ways to do this?
In version 23R1 it is possible to create Quick Reports using Query Designer. Here's a little nasty workaround to 22R2: With the following SQL query you can generate the SQL code using the "Query Name": SELECT IFSAPP.Query_Designer_Sql_Util_API.Generate_Sql_Statement('QueryName') AS Query FROM dual The result of the query returns a Select statement, which can be used in a quick report.
I have found the following links useful:https://dsj23.me/2021/01/08/ifs-authentication-flow-with-oauth-and-openid-connect/https://docs.ifs.com/techdocs/Foundation1/050_development/024_integration/010_restful_odata/default.htm
Hi,I am also looking for a best practice here. Integrating the Oracle database directly would be the easiest, but I guess it's not allowed due to licensing reasons. Therefore, I will probably create quick reports with the required information and read them out via the REST-API. The whole process can be automated and could be updated every x minutes.Does anyone know an simpler way?
Already have an account? Login
No account yet? Create an account
Enter your 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.