zoho array

[ingen...@bammtech.cl]

how can I make an array with the zoho crm accounts using Get a list of all the accounts connector?

[Sushma Padidela]

Hi,

The connector which is in RunMyProcess library "Get a list of all the accounts "gives output in xml format. There is also Zoho API to get list of accounts in json format.

https://www.zoho.com/crm/help/api/getrecords.html#e1

Example from Zoho Documentation:

https://crm.zoho.com/crm/private/json/Accounts/getRecords?newFormat=1&authtoken=sbdjEDBDJ445791323

&scope=crmapi&fromIndex=20&toIndex=200&sortColumnString=Account Name&sortOrderString=desc

You can create your own provider and connector like attached screenshot.

To do transformation of output from one format to other you can follow the Documentation below.

http://docs.runmyprocess.com/API_Reference/FM/Utilities.html

Thanks,

Sushma

Fujistu RunMyProcess

On Wed, Feb 4, 2015 at 8:07 AM, <ingen...@bammtech.cl> wrote:

how can I make an array with the zoho crm accounts using Get a list of all the accounts connector?

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://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/82acd5e8-e154-43a7-9afd-c728001c8e1c%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Sushma Padidela]

Hi,

Sorry for the previous incomplete email, it was sent by mistake.

Your configuration looks fine but the error may be caused due to space in "Account Name". Can you try to use URL encoding while passing parameters in the Zoho API URL. Please try with the below in the connector URL and you don't need to pass any value for "Account Name" even if it is in $ format.

json/Accounts/getRecords?newFormat=1&authtoken=****&scope=crmapi&fromIndex=20&toIndex=200&sortColumnString=${"Account Name"?url}&sortOrderString=desc

Thanks,

Sushma

Fujitsu RunMyProcess

On Fri, Feb 6, 2015 at 1:24 PM, Sushma Padidela <spad...@runmyprocess.com> wrote:

Hi,

Can you try to use URL encoding while passing parameters in the Zoho API URL.

 

json/Accounts/getRecords?newFormat=1&authtoken=****&scope=crmapi&fromIndex=20&toIndex=200&sortColumnString=Account Name&sortOrderString=desc

On Fri, Feb 6, 2015 at 9:47 AM, Grupo Ingenieria <ingen...@bammtech.cl> wrote:

I have this error in my process test

java.net.URISyntaxException: Illegal character in query at index 112: https://crm.zoho.com/crm/private/json/Accounts/getRecords?newFormat=1&authtoken=****
&scope=crmapi&fromIndex=20&toIndex=200&sortColumnString=Account Name&sortOrderString=desc

this is my connector

my provider

in the process as input variables I use my authrntication token and the scope variable crmapi

what can be the error?