Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagegroovy
linenumberstrue
package com.example;
 
import com.belladati.extension.BaseExtensionEndpoint;
import org.apache.tapestry5.StreamResponse;
import com.belladati.json.JSONArray;
import com.belladati.json.JSONObject;

public class MyEndpoint extends BaseExtensionEndpoint {
  def row
  def values
  public StreamResponse doGet() {
    try {
      def dataset = loadDataset(123456);
      JSONArray data = new JSONArray();
      readDatasetData(dataset, null) { //loads data per row
          JSONObject d = new JSONObject();
          def rowID = row.getRowId();
          d.put("rowID", String.valueOf(rowID));
          for (e in values) {
            def k = e.key
            def v = e.value
            d.put(k, String.valueOf(v));
      	  }
          data.add(d);
      }
      return createStreamResponse(data.toJSONString());
    } catch (Exception e) {
      return createStreamResponse("error: " + e);
    }
  }
}

Reading filtered and sorted data from data set

Code Block
languagegroovy
package com.example;
import com.belladati.extension.BaseExtensionEndpoint;
import org.apache.tapestry5.StreamResponse;
import com.belladati.bi.biz.report.view.settings.Filter;
import com.belladati.bi.biz.report.view.settings.OperationType;
import com.belladati.json.JSON;
import com.belladati.json.JSONArray;
import com.belladati.json.JSONObject;
public class MyEndpoint extends BaseExtensionEndpoint {
def row
  def values
	@Override
	public StreamResponse doGet() {
        try {
          //console.log(param);
          def dataset = loadDataset(123456);
           def attribute = getDatasetAttribute(dataset, "L_CURRENCY");
          Filter f = new Filter()
          f.and(attribute, OperationType.IN, "HDK");
          String filter = buildFilter(dataset, f);
                JSONArray data = new JSONArray();
          def key = readDatasetData(dataset,filter,1,10,"L_CUSTOMER DESC") {//loads data per row
              JSONObject d = new JSONObject();
              def rowID = row.getRowId();
              d.put("id", String.valueOf(rowID));
              for (e in values) {
                def k = e.key
                def v = e.value
                if (v != null) {
                  d.put(k, String.valueOf(v)); 
                }
              }
                data.add(d);
        }
          return createStreamResponse(data.toJSONString());
          } catch (Exception e) {
          return createStreamResponse("error: " + e);
        }
	}
	@Override
	public StreamResponse doPost() {
		// TODO Auto-generated method stub. Please insert here your code for POST operation.
		return createStreamResponse("OK", "text/plain", 200);
	}
	
}

 

Sending SOAP request to 3rd party system

...