import data into a collection

[ingen...@bammtech.cl]

I have a google spreadsheet with a price list and it is very extensive for all the data that it has. My question is, is it possible to import all the data into a collection of simple and fast way?

[Bidisha Das]

Hi,

There are two ways you can do it:

1.You can directly download the spreadsheet on RMP in CSV format using add file option and then use ${import_objects("file id", "Collection name", ",", "true")} to save into collection.If you want the file data to append with the collection data,you can use false inside it. File id will be automatically generated when you add file to the project.

You can also use Google Connectors for the same purpose- Login Spreadsheet and Download a spreadsheet to RMP [v3] in Process.

2.If you want to dynamically populate Collection from Google Spreadsheet, you can use a series of Google Connectors: Login Spreadsheet, Get the id of a spreadsheet [V 3.0], Get the id of a worksheet [V 3.0], Get all rows [v3] and then use freemarker code to save the retrieved records into collection.

Thanks & Regards

Bidisha

[Grupo Ingenieria]

can you show me where I have to write that code?

${import_objects("file id", "Collection name", ",", "true")}

I import my spreadshet in csv format.

my collection calls "sku1" and my file id its "e0b672b0-c1a7-11e4-85c7-123139225512"

I though that I have to do a composite API and it looks like this:

I dont have any design or something, just that, and when I test it I have this problem:

this is my collection and my file in csv format

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/dho0ZmfRybA/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAMGV9zso7BHAP4%2BEAsv0d9cbJn-oLNQgmcoYb_wdc2vjLw4FaA%40mail.gmail.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Shobhit Tripathi]

Hi,

You do not have to pass this in the input validation field. You need to pass this code ( ${import_objects("file_id","collection_name", ",", "true/false")} ) in the design tab of your CAPI inside the "input variable".

As per screenshot it seems that you are not using double quotes as well while passing the file id and collection name.

Note: It is recommended to use "read only" while using collection for security purpose.

Hope this will help you. Feel free to ask.

Thanks & Regards,

Shobhit

Fujitsu- RunMyProcess