Consume collection object from google script

[cst...@ferreyros.com.pe]

Good afternoon, I have a code in google apps script, in which I want to consume information that is found in runmyprocces such as a collection object, is it possible?

[Abhilash Sambhare]

Hi Sir,

RunMyProcess platform provides inbuilt connectors to retrieve the data from collection into third party via webservices.

Please go through the RMP connectors library.The details of the connectors are as follows:

Provider name:RunMyProcess - Secured Connection

Connector:Get items from a collection

Hope this helps you.Please don't hesitate to contact us for any query.

Thanks & Regards,

Abhilash Sambhare

Fujitsu RunMyProcess Support

On Wed, Apr 12, 2017 at 1:34 AM, <cst...@ferreyros.com.pe> wrote:

Good afternoon, I have a code in google apps script, in which I want to consume information that is found in runmyprocces such as a collection object, is it possible?

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/341578c6-eec8-484f-a6c7-5b02928e2d24%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Cstirmp Outsourcing]

If I already know that, what I want is to consume it from google apps script; That is, runmyprocess the service server and google apps script the client

[Abhilash Sambhare]

Hi Sir,

Good Day.

As per my understanding,you want to retrieve the data(collection/database) from your runmyprocess account into google apps account.

To achieve this functionality, you need to use connector/API("Get items from a collection") to retrieve stored data from runmyprocess collection into third party.(in your case Google Apps account).

You need to write a code in Google Apps code/script which is responsible to trigger RunMyProcess and  use mentioned connector("Get items from a collection") configuration into your google apps script to fetch all those required results. 

For eg: https://live.runmyprocess.com/live/${P_customer}/object/${col_name}/?P_mode=${execution_mode}&P_query=${query?url}&P_first=${first}&P_nb=${nb}

Hope this hepls you.Kindly let us know if you still have any query/doubt.

Thanks & Regards,

Abhilash Sambhare

Fujitsu RunMyProcess Support

On Wed, Apr 12, 2017 at 6:49 PM, Cstirmp Outsourcing <cst...@ferreyros.com.pe> wrote:

If I already know that, what I want is to consume it from google apps script; That is, runmyprocess the service server and google apps script the client

[Cstirmp Outsourcing]

If a favor is correct, a favor if you would have an example with screenshot would appreciate it enough.

Greetings.

[Ghanshyam Mule]

Hello,

I have created sample google app script for fetching  data from RunMyProcess Collection.

Kindly find code  below:-

function myFunction() {

  var USERNAME = "xxxxxx";     // username of Runmyprocess Account

  var PASSWORD = "xxxxxx";    //password of RunMyProcess Account

  var customer_identifier=661134565;   //Customer identfier no of an account

  var query = {};      // condition to fetch data

  var collection_name="xxxxx";   //name of the collection

  var mode="xxxx";        // the execution mode.

  var first_element=0;      // first element of result. By default it is 0.

  var no_of_records=3;     //no. of records you want to fetch

  var url = 'https://live.runmyprocess.com/live/';

  var mode_first_element_and_no_of_record_string = '/?P_mode=' + mode + '&P_first=' + first_element + '&P_nb=' +               no_of_records ;

  var finalUrl = url + customer_identifier + '/object/' + collection_name + mode_first_element_and_no_of_record_string + '&P_query=' + encodeURIComponent(Utilities.jsonStringify(query)); 

  var headers = {

    "Authorization" : "Basic " + Utilities.base64Encode(USERNAME + ':' + PASSWORD)

  };

  var options = {

    'method': 'get',

    'headers': headers

  };

  var response = UrlFetchApp.fetch(finalUrl, options);  

  var json = response.getContentText();

  var data = JSON.parse(json);

  Logger.log(data);

}

Let me know if any concern.

Regards,

Ghanshyam Mule

Fujitsu RunMyProcess Support

On Thu, Apr 13, 2017 at 6:38 PM, Cstirmp Outsourcing <cst...@ferreyros.com.pe> wrote:

If a favor is correct, a favor if you would have an example with screenshot would appreciate it enough.

Greetings.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAEK60XOGKFdRn0WfC7Q5GTMWLsc8EQTs8YC_tRH2YjrctTU4Kw%40mail.gmail.com.

[Cstirmp Outsourcing]

If this is what I needed, thank you