edgars

package mine;

import ballerina.net.http;

@http:configuration {basePath:"/dolar"}
service<http> dolar {
    endpoint
    
     <http:HttpClient> httpConnector{
        create http:HttpClient("http://api.bcb.gov.br", {});}

edgars

<?xml version="1.0" encoding="UTF-8"?>
<sequence name="GenerateInvoiceId" trace="disable"
    xmlns="http://ws.apache.org/ns/synapse">
    <call blocking="true" description="">
        <endpoint>
            <http method="get" uri-template="http://www.mocky.io/v2/594c61e4110000b10ea3d048"/>
        </endpoint>
    </call>
         <enrich>
            <source type="body" clone="true"/>

edgars

<?xml version="1.0" encoding="UTF-8"?>
<sequence name="invoke-hotel-car-sequence_v2" trace="disable" xmlns="http://ws.apache.org/ns/synapse">
    <log>
        <property name="Message Flow" value="Travel Sequence"/>
    </log>
    <call>
        <endpoint>
            <http method="get" uri-template="http://www.mocky.io/v2/594c61e4110000b10ea3d048"/>
        </endpoint>
    </call>

edgars

Verifying that "edgars.id" is my Blockstack ID. https://onename.com/edgars

edgars

import org.wso2.ballerina.connectors.salesforcesoap;
import ballerina.lang.system;
import ballerina.lang.xmls;
import ballerina.net.http;
import ballerina.lang.messages;
import ballerina.lang.jsons;

@http:BasePath{value:"/query"}
service sfdc {

edgars

import ballerina.data.sql;
import ballerina.lang.messages;
import ballerina.lang.datatables;
import ballerina.lang.jsons;
import ballerina.lang.exceptions;
import ballerina.lang.strings;
@http:BasePath("/employees")
service Employees {
	string dbURL = "jdbc:mysql://localhost:3306/mycrm";
	string username = "root";

edgars

function responseException(string resourceName, exception e)(json ) {
	string errorMessage = strings:trim(exceptions:getMessage(e));
	json payload = `{${resourceName}:${errorMessage}}`;
	return payload;
	
}

edgars

	@http:GET
	@http:Path("/")
	resource select(message m) {
		sql:Parameter[] params = [];
		try {
			datatable dt = sql:ClientConnector.select(lcDBConnector, "select empno,ename,job,mgr,hiredate,sal,comm,deptno from emp", params);
			json payload = datatables:toJson(dt);
			message response = {};
			messages:setJsonPayload(response, payload);
			reply response;

edgars

	string dbURL = "jdbc:mysql://localhost:3306/mycrm";
	string username = "root";
	string password = "mysql";
	map propertiesMap = {"jdbcUrl":dbURL, "username":username, "password":password
	}
	;
	sql:ClientConnector lcDBConnector = create sql:ClientConnector(propertiesMap);

edgars

import ballerina.data.sql;
import ballerina.lang.messages;
import ballerina.lang.datatables;
import ballerina.lang.jsons;
import ballerina.lang.exceptions;
import ballerina.lang.strings;
@http:BasePath("/employees")
service Employees {

	@http:GET