how to update recor in spreadsheet

118 views
Skip to first unread message

edgar....@totalgas.com

unread,
Sep 23, 2013, 5:42:26 PM9/23/13
to suppor...@runmyprocess.com
Can you help us to solve this issue
Error: 2013-09-21T00:38:19+0000 - Task "Actualizar spreaadsheet" (id: 14[0] - status: ACTIVE): Unsupported Media Type

This error appear when we try to update google Spreadsheet

Cordialy
Edgar Montoya

Message has been deleted

madhuri.ru...@gmail.com

unread,
Sep 24, 2013, 2:51:06 AM9/24/13
to suppor...@runmyprocess.com, edgar....@totalgas.com

Hi,
What kind of connector are you using?
There are different kinds of media types in connector configuration.
Your request and response of connector should support same type of data stream.
Please select appropriate media type from drop down(PFA) as per your data type.

Thanks,
Madhuri,Fujitsu

Media_Type.png

edgar....@totalgas.com

unread,
Sep 24, 2013, 2:58:37 PM9/24/13
to suppor...@runmyprocess.com, edgar....@totalgas.com, madhuri.ru...@gmail.com
On Tuesday, September 24, 2013 1:51:06 AM UTC-5, madhuri.ru...@gmail.com wrote:
> On Tuesday, September 24, 2013 3:12:26 AM UTC+5:30, edgar....@totalgas.com wrote:
> > Can you help us to solve this issue
> > Error: 2013-09-21T00:38:19+0000 - Task "Actualizar spreaadsheet" (id: 14[0] - status: ACTIVE): Unsupported Media Type
> >
> > This error appear when we try to update google Spreadsheet
> >
> > Cordialy
> > Edgar Montoya
>
> Hi,
> What kind of connector are you using?
> There are differhttps://groups.google.com/forum/clear.cache.gifent kinds of media types in connector configuration.

> Your request and response of connector should support same type of data stream.
> Please select appropriate media type from drop down(PFA) as per your data type.
>
> Thanks,
> Madhuri,Fujitsu

Hi,
I used the Add a row [v3], can you help us solve this issue

Cordially
Edgar Montoya

rmp_conn_used.jpg

edgar....@totalgas.com

unread,
Sep 26, 2013, 3:01:47 AM9/26/13
to suppor...@runmyprocess.com, edgar....@totalgas.com

Hi!
My output variable from google spreadsheet login is:
name=Auth Value=${P_result.Auth}
Now my error process is 2013-09-25T19:00:56+0000 - Task "Actualizar spreaadsheet" (id: 14[0] - status: ACTIVE): Unknown authorization header

My variables
<gsx:Fecha>${fecha}</gsx:Fecha> Date type

<gsx:Solicitante>${P_initiator.name}</gsx:Solicitante>

<gsx:Correo>${P_initiator.login}</gsx:Correo>

<gsx:Estacion>${estacion}</gsx:Estacion> String type

<gsx:Grupo>${group_id}</gsx:Grupo> String type

<gsx:Noparte>${mat_id}</gsx:Noparte> String type

<gsx:Material>${material}</gsx:Material> String type

<gsx:Cantidad>${cantidad}</gsx:Cantidad>number type

My Access media type is */* too.

rmp_var.jpg

madhuri.ru...@gmail.com

unread,
Sep 26, 2013, 4:27:29 AM9/26/13
to suppor...@runmyprocess.com, edgar....@totalgas.com

Hi,
When you use login spreadsheet connector and login to spreadsheet with your google account,you get Auth token,as you said ${P_result.Auth}
You need to pass this as input for adding row in spreadsheet.
your Auth token may have expired.
Please login and execute.

Thanks,
Madhuri,Fujitsu

edgar....@totalgas.com

unread,
Sep 26, 2013, 1:27:39 PM9/26/13
to suppor...@runmyprocess.com, edgar....@totalgas.com, madhuri.ru...@gmail.com
The issue continue, I need personalize help, how can I get

Cordially
Edgar Montoya

Sabine El Rassy

unread,
Sep 26, 2013, 6:22:39 PM9/26/13
to RunMyProcess Support Forum, edgar....@totalgas.com, madhuri.ru...@gmail.com
Hello Edgar,

Try to put your tags in lowercase   <gsx:Fecha>${fecha}</gsx:Fecha> =>   <gsx:fecha>${fecha}</gsx:fecha>
Keep me posted if that works for you.

Regards,

Sabine

edgar....@totalgas.com

unread,
Sep 27, 2013, 2:03:13 PM9/27/13
to suppor...@runmyprocess.com, edgar....@totalgas.com, madhuri.ru...@gmail.com
Hi!
Thanks with your post works fine.

Cordially
Edgar Montoya
Reply all
Reply to author
Forward
0 new messages