How to export data to excel in OutSystem

Step 1:- Create a link and add Destination as a new action to the it



Step 2:- Double click on Action and have your work flow as shown below



Step 3:- click on Excel icon in work Flow and fill the parameter as shown below



Step 4:- Click on download icon in Work flow and fill the parameter as shown below





Step 5:- Run the appication and click on the link and excel will be downloaded to your system

How to Create Graph in Outsystem

Step 1:- To create a graph we need to create a list i.e. collection of record on which we want to plot the graph
Step 2:- Lets assum we want to crate a graph on our Employees List Screen.
- Create a Container component
- Create local Varable and name it as saaryGraph
- Make sure to give the Data Type as Employee List

Step 3:- Create a graph i.e. we are creating bar chart select Column Chart


Step 4:- click on the bar cart window and fill parameter as shown below

Step 5:- Run the application and see the graph displayed on the screen

Calling SOAP Web Service API Example using Outsystem Application

Step 1:- Create One text field and button as shown in the above screen
Step 2:- Create Destination as shown in the below figure

Step 3:- Go to logic and create a new SOAP Service as shown in the below figure.

Step 4:- Double click on the button and keep your button Flow diagram as shown below i.e. drag drop our SOAP Method to flow and assign the output to variable we had assigned to Text field.

Step 5:- Compile and run the application

Calling REST API Example using Outsystem

Step 1:- Create One text field and button as shown in the above screen

Step 2:- Create Destination as shown in the below figure

Step 3:- Go to logic and create a new REST Service as shown in the below figure.



Step 4:- Double click on the button and keep your button Flow diagram as shown below i.e. drag drop our REST Method to flow and assign the output to variable we had assinged to Text field.


Step 5:- Compile and run the application

OutSystems CRUD Operation Example

Step 1:- Please refer to the below given link before starting the application

http://siddharathadhumale.blogspot.in/2017/06/addition-of-two-value-in-outsystems.html

Step 2:- We are going to add a button that will move us to a screen that will perform CRUD operation
Step 3:- Goto Data Tab and right click and create a table ie Employee

Step 4:- Create necessary Field in that table, Note:- By default we will have ID as a PK in the table ready.

Step 5: - Click on Main flow and Drag and drop List and Detail Screen and select Employee option as shown in below figure.


Step 6:- Lets add back button on the Screen that will navigate us to Home page


Step 7:- Click on Back Button and add this to it

Addition of two value in outsystems application

Step1:- Create your login in outsystems
Step 2:- Download Environment IDE from the site. i.e. https://www.outsystems.com/home
Step 3:- Install the new exe DevelopmentEnvironment-10.0.502.0.exe to your system
Step 4:- Login to IDE and input your Environment name i.e. abc-xyz.outsystemscloud.com and use your login credential to get access your Development Environment on cloud.
Step 5:- Click on Home screen icon shown in below image.

Step 6:- Create your Addition of two value programe using inbuild component like Label, Textfield, Button as shown in below image


Step 7:- Make sure to assign local variable to your Textfield. This Local variable is used to identify out component by applications.


Step 8:- Double click on Add button and used Assign component in flow, and see the right hand side below component to apply logic



Note:- Dont Forget to make your Var1,Var2 and Var3 Interger else value be concatinated.

Integrating Paypal Payment gateway in our Web Application using JAVA

Step 1 - Create gmail Id that we are going to use as a paypal reference i.e. TestingPaypalgateway@gmail.comStep 1 - Create gmail Id that we are going to use as a paypal reference i.e. TestingPaypalgateway@gmail.comStep 2 - Open this url and click on signup and register above created user in paypal i.e. TestingPaypalgateway@gmail.comhttps://developer.paypal.com/

Step 3 - Login with TestingPaypalgateway@gmail.com in paypal and go to account section of the screen. we will be able to see the below screen.

Paypal will create two email id for us 1- *-facilitator@gmail.com of Type business 2- *-buyer@gmail.com of type personal or individual
Step 4:- Go to My Apps $Credentials screen and generate Sand box Access Token. This token is needed when we try to make Financial transactions.

Click on the button and fill select *-facilitator@gmail.com of Type business in combobox.

Step 5:-click on Generate Credential button and we will see Access token created for us in sandbox for use. On the same screen we can also define the currency in which we are going to use the transaction.
Note: This Access token has an expiry

Step 6:-After adding the access token to our id we will be able to see this facilitator id on on My Apps & credentials Screen as shown below

Step 7:- Now lets try to implement PayPal payment services. Choose the solution that bests suits your needs
Refer to this page https://developer.paypal.com/docs/
We will try to use the simple yet effective option of checking out and paying the purchase product on line using Paypal.
https://developer.paypal.com/docs/integration/direct/express-checkout/integration-jsv4/
- Create simple dynamic web project and create an index.jsp in our webcontent
place following code inside it
<!--%@ page language="java" contentType="text/html; charset=ISO-8859-1"<!--%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%><!--!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><!--html><!--head><!--meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><!--title>Insert title here<!--/title><!--meta http-equiv="X-UA-Compatible" content="IE=edge" /><!--script src="https://www.paypalobjects.com/api/checkout.js"><!--/script><!--/head><!--body>
<!--h2>hello siddhu<!--/h2> <!--div id="paypal-button"><!--/div>
    <!--script>        paypal.Button.render({
            env: 'production', // Or 'sandbox',
            commit: true, // Show a 'Pay Now' button
            payment: function() {                // Set up the payment here            },
            onAuthorize: function(data, actions) {                // Execute the payment here           }
        }, '#paypal-button');    <!--/script><!--/body><!--/html>
When you run above code you will be able to see a paypal button on the screen.


Now we need to add logic that will work for us to do payment using Paypal. for this we will use Client-side REST integration
For this we need to create a client id and for that we have to follow below given steps.
1- Go to  PayPal developer My apps page, and click the top right button to log in.2- Scroll down to the REST API Apps section. If you do not have any apps listed in this section, create a PayPal app i.e. https://developer.paypal.com/developer/applications/createand and copy paste the cliend id for our app created and then return to the REST API Apps section.
Modify above code with this lines which state that we are going to
<!--%@ page language="java" contentType="text/html; charset=ISO-8859-1"<!--%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%><!--!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><!--html><!--head><!--meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><!--title>Insert title here<!--/title><!--meta http-equiv="X-UA-Compatible" content="IE=edge" /><!--script src="https://www.paypalobjects.com/api/checkout.js"><!--/script><!--/head><!--body>
<!--h2>hello siddhu<!--/h2> <!--div id="paypal-button"><!--/div>
<!--script> paypal.Button.render({
env : 'sandbox', // Or 'production'
client : { sandbox : 'ASEbOgMkFPF1J2nYV3CbDb8k7JSfWveIHDdsVjJrqEtAQeBJsvavDtuN1ULZABXREGx3UdfEyDGcVNpn', production : 'xxxxxxxxx' },
commit : true, // Show a 'Pay Now' button
payment : function(data, actions) { return actions.payment.create({ transactions : [ { amount : { total : '1.00', currency : 'USD' } } ] }); },
onAuthorize : function(data, actions) { return actions.payment.execute().then(function(payment) {
window.alert("Payment done successfully!!!!!!");
// The payment is complete! // You can now show a confirmation message to the customer }); }
}, '#paypal-button'); <!--/script><!--/body><!--/html>


As I am acting as a buyer so I had used my buyer emailid and password.


Refer to the below url for more in details:-https://developer.paypal.com/docs/integration/direct/express-checkout/integration-jsv4/add-paypal-button/https://developer.paypal.com/docs/integration/direct/express-checkout/integration-jsv4/choose-integration-method/