[prev in list] [next in list] [prev in thread] [next in thread]
List: vtigercrm-developers
Subject: Re: [Vtigercrm-developers] REST
From: Nicolas Larcipretti <niclarcipretti () gmail ! com>
Date: 2012-01-16 17:42:55
Message-ID: CAK10WeDfeURBS0uQv8_yV0ts8-V3Av+ENJikaAHuwbGKu6kVsQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Here's the JSON i've used to do it, hope it helps:
{"potentialname":"someName","potential_no":"O40812","amount":"1000.00","related_to":"3 \
x21363","closingdate":"2008-03-20","opportunity_type":"","nextstep":"","leadsource":"Outra","sales_stage":"Encerrada
e
Desqualificada","assigned_user_id":"20x719","probability":"50.000","campaignid":"","createdtime":"2008-03-14
00:00:00","modifiedtime":"2008-03-14
00:00:00","cd_territorio":"32x84000","cd_territorio_parceiro":"","cf_675":"0%","cf_676":"some","cf_683":"N\u00e3o
Possui","cf_689":"123","cf_696":"","cf_697":"","cf_698":"some
text","cf_699":"","cf_700":"","cf_701":"","cf_702":"","cf_703":"","cf_704":"","cf_705" \
:"","cf_706":"","cf_707":"","cf_708":"","cf_709":"","cf_710":"","cf_711":"","cf_712":" \
Ganhador","cf_713":"Ganhador","cf_714":"0.00","cf_715":"0.00","cf_716":"Desconhecido", \
"cf_717":"Desconhecido","cf_718":"","cf_719":"","cf_722":"0","cf_723":"0","cf_724":"0" \
,"cf_725":"0","cf_726":"0","cf_727":"","cf_728":"","cf_729":"","cf_730":"","cf_731":"5 \
","cf_732":"","cf_733":"0","cf_763":"","cf_764":"","cf_765":"0","cf_766":"0","cf_767": \
"0","cf_768":"0","cf_769":"0","cf_770":"0","cf_771":"0","cf_772":"100","cf_773":"50","cf_774":"50","id":"5x115877"}'
Cheers
Nicolas
2012/1/16 Nicolas Larcipretti <niclarcipretti@gmail.com>
> Bobo,
>
> I've tested it here with accounts and potentials and both worked fine
> setting a group as the record's owner (used the admin user to do it). But
> now I think I know what's wrong with your call. Try to add an "id"
> attribute to your json with the same value as the "potential_id", that's
> the only thing missing.
>
> I'm using the 5.2.1 too.
>
> Cheers
>
> Nicolas
>
> 2012/1/16 Bobo Wieland <bobo@prisjakt.nu>
>
> > I havn't had any problems with create/update using a non-admin user in
> > any other respect. But I tried to change my user to be admin, and also to
> > put the user in the group that Iäm trying to assign the potential to.
> >
> > I still get the same error message. Does anyone else have this problem?
> > Anyone that can verify it?
> >
> > btw, using vtiger 5.2.1...
> >
> >
> > Nicolas Larcipretti skrev 2012-01-13 13:15:
> >
> > When you create you session, do you use an admin user? Cause, AFAIK,
> > they're the only ones that can perform changes on any record. If you're
> > using any other user that doesn't have admin privileges, this will trigger
> > the "access denied" error.
> >
> > Cheers
> >
> > Nicolas
> >
> > 2012/1/13 Bobo Wieland <bobo@prisjakt.nu>
> >
> > > I'm 100% sure that the session is correct. I havn't posted the whole
> > > chain of events here, but this is what I've done:
> > >
> > > 1. Verified my credentials and got a correct session.
> > > 2. Fetched a potential that I know to be assigned to a group (20x1756).
> > > 3a. Tried to change something in the potential and the update it without
> > > changing assigned_to. This causes the error.
> > > 3b. Create a new potential/edit another potential and set assigned_to to
> > > 20x1756. This causes the error (assigning the potential to a user (19xXXXX)
> > > works).
> > >
> > > This is all through the REST api using curl.
> > >
> > > Nicolas Larcipretti skrev 2012-01-13 12:58:
> > >
> > > Well, I've never used curl to do this before, but I think it can be used
> > > without problems.
> > >
> > > Your request seems fine to me, the only things you need to check are:
> > > - the "sessionName", cause if you create the token in the wrong way, it
> > > won't let you finish the request.
> > > - the related id's that you're sending.
> > >
> > > Are you shure that your group id is 1756? I don't know how many users
> > > you have, but usualy that a pretty high number to a group.
> > >
> > > Can you show us how are you creating your session?
> > >
> > > Cheers.
> > >
> > > Nicolas
> > >
> > > 2012/1/13 Bobo Wieland <bobo@prisjakt.nu>
> > >
> > > > Sure.
> > > >
> > > > Data array:
> > > >
> > > > [amount] => 0.00
> > > > [referenceid] =>
> > > > [special_price] => 0
> > > > [email] =>
> > > > [countrybusiness] => SE
> > > > [price_type] => Pricegroup A
> > > > [expected_close_date] => 2012-01-09
> > > > [created_time] => 2012-01-09 10:53:48
> > > > [description] => 120109/SalesBot - Självprofilering
> > > > 2012-01-09/SalesBot new status.
> > > >
> > > > [modified_time] => 2012-01-13 10:25:50
> > > > [next_step] =>
> > > > [potential_name] => Featured Store - demo
> > > > [type] => Featured Store
> > > > [potential_no] => POT3232
> > > > [probability_(%)] => 0.00
> > > > [related_to] => 3x793
> > > > [sales_stage] => Closed Won
> > > > [assigned_to] => 20x1756
> > > > [potentialid] => 5x53741
> > > >
> > > >
> > > >
> > > > This is the raw curl command:
> > > >
> > > > /usr/bin/curl --header 'Expect:' --header 'Authorization: Basic <CODE>'
> > > > --include --url '<VTIGER_URL>/webservice.php' --data
> > > > 'element=%7B%22amount%22%3A%220.00%22%2C%22cf_507%22%3A%22%22%2C%22cf_629%22%3 \
> > > > A%220%22%2C%22cf_630%22%3A%22%22%2C%22cf_703%22%3A%22SE%22%2C%22cf_705%22%3A%2 \
> > > > 2Pricegroup+A%22%2C%22closingdate%22%3A%222012-01-09%22%2C%22createdtime%22%3A \
> > > > %222012-01-09+10%3A53%3A48%22%2C%22description%22%3A%22120109%5C%2FSalesBot+-+ \
> > > > Sj%5Cu00e4lvprofilering%5Cn2012-01-09%5C%2FSalesBot+new+status.%5Cn%22%2C%22mo \
> > > > difiedtime%22%3A%222012-01-13+10%3A25%3A50%22%2C%22nextstep%22%3A%22%22%2C%22p \
> > > > otentialname%22%3A%22Featured+Store+-+demo%22%2C%22opportunity_type%22%3A%22Fe \
> > > > atured+Store%22%2C%22potential_no%22%3A%22POT3232%22%2C%22probability%22%3A%22 \
> > > > 0.00%22%2C%22related_to%22%3A%223x793%22%2C%22sales_stage%22%3A%22Closed+Won%2 \
> > > > 2%2C%22assigned_user_id%22%3A%2220x1756%22%2C%22id%22%3A%225x53741%22%7D&operation=update&sessionName=672515d54f100e7a0cc2e'
> > > >
> > > >
> > > > Nicolas Larcipretti skrev 2012-01-13 11:36:
> > > >
> > > > Can you paste here your entire REST call? I might help you cause I
> > > > have a method that does group creation via webservice here.
> > > >
> > > > Cheers
> > > >
> > > > Nicolas
> > > >
> > > > 2012/1/13 Bobo Wieland <bobo@prisjakt.nu>
> > > >
> > > > > Coming back to this issue. Just ignored it for a while.
> > > > >
> > > > > Trying to set assigned_to for a potential to "20x1756" (which is a
> > > > > valid group that many potentials is assigned to in our vtiger system) still
> > > > > gives me the error message:
> > > > >
> > > > > "Cannot assign record to the given user (ACCESS_DENIED)"
> > > > >
> > > > > I do this using the REST Web Services using "update"
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > praneeth K skrev 2011-10-28 12:51:
> > > > >
> > > > > Hi ,
> > > > >
> > > > >
> > > > > Generally group id will be in the format of '20x*groupId*'. I hope
> > > > > you are passing id to the REST api in the same format.
> > > > >
> > > > > On Fri, Oct 28, 2011 at 1:51 PM, Bobo Wieland <bobo@prisjakt.nu>wrote:
> > > > >
> > > > > > Using the REST-api, is it possible to set "assigned_to" for a
> > > > > > Potential
> > > > > > to a Group? I get an ACCESS_DENIED when I try even though it works
> > > > > > perfectly to set it to a group using the standard webinterface.
> > > > > >
> > > > > > best regards
> > > > > > Bobo Wieland - bobo@prisjakt.nu
> > > > > > _______________________________________________
> > > > > > iger.com/
> > > > >
> > > > >
> >
> > --
> > *Med vänliga hälsningar
> > Bobo - bobo@prisjakt.nu*
> >
> > _______________________________________________
> > http://www.vtiger.com/
> >
>
>
[Attachment #5 (text/html)]
Here's the JSON i've used to do it, hope it \
helps:<br><br>{"potentialname":"someName","potential_no" \
:"O40812","amount":"1000.00","related_to":&quo \
t;3x21363","closingdate":"2008-03-20","opportunity_type& \
quot;:"","nextstep":"","leadsource":"Outra","sales_stage":"Encerrada \
e Desqualificada","assigned_user_id":"20x719","probabili \
ty":"50.000","campaignid":"","createdtime":"2008-03-14 \
00:00:00","modifiedtime":"2008-03-14 \
00:00:00","cd_territorio":"32x84000","cd_territorio_parc \
eiro":"","cf_675":"0%","cf_676":"some","cf_683":"N\u00e3o \
Possui","cf_689":"123","cf_696":"","cf_697":"","cf_698":"some \
text","cf_699":"","cf_700":"","cf_70 \
1":"","cf_702":"","cf_703":"",& \
quot;cf_704":"","cf_705":"","cf_706":&quo \
t;","cf_707":"","cf_708":"","cf_709& \
quot;:"","cf_710":"","cf_711":"",&qu \
ot;cf_712":"Ganhador","cf_713":"Ganhador","cf_ \
714":"0.00","cf_715":"0.00","cf_716":&quo \
t;Desconhecido","cf_717":"Desconhecido","cf_718":&q \
uot;","cf_719":"","cf_722":"0","cf_7 \
23":"0","cf_724":"0","cf_725":"0&quo \
t;,"cf_726":"0","cf_727":"","cf_728" \
:"","cf_729":"","cf_730":"","cf \
_731":"5","cf_732":"","cf_733":"0&qu \
ot;,"cf_763":"","cf_764":"","cf_765" \
:"0","cf_766":"0","cf_767":"0"," \
;cf_768":"0","cf_769":"0","cf_770":" \
0","cf_771":"0","cf_772":"100","cf_7 \
73":"50","cf_774":"50","id":"5x115877"}'<br>
<div class="gmail_quote"><br>Cheers<br><br>Nicolas<br>2012/1/16 Nicolas Larcipretti \
<span dir="ltr"><<a \
href="mailto:niclarcipretti@gmail.com">niclarcipretti@gmail.com</a>></span><br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Bobo,<br><br>I've tested it here with accounts and \
potentials and both worked fine setting a group as the record's owner (used the \
admin user to do it). But now I think I know what's wrong with your call. Try to \
add an "id" attribute to your json with the same value as the \
"potential_id", that's the only thing missing.<br>
<br>I'm using the 5.2.1 too.<br><br>Cheers<br><br>Nicolas<br><br><div \
class="gmail_quote">2012/1/16 Bobo Wieland <span dir="ltr"><<a \
href="mailto:bobo@prisjakt.nu" target="_blank">bobo@prisjakt.nu</a>></span><br> \
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div><div class="h5">
<div bgcolor="#FFFFFF" text="#000000">
<font color="#888888">I havn't had any problems with create/update
using a non-admin user in any other respect. But I tried to change
my user to be admin, and also to put the user in the group that
Iäm trying to assign the potential to.<br>
<br>
I still get the same error message. Does anyone else have this
problem? Anyone that can verify it?<br>
<br>
btw, using </font><span style="color:#999999">vtiger
5.2.1...</span><br>
<font color="#888888"><br>
<br>
</font>Nicolas Larcipretti skrev 2012-01-13 13:15:
<blockquote type="cite"><div><div>When you create you session, do you use an \
admin user? Cause, AFAIK, they're the only ones that can perform changes on
any record. If you're using any other user that doesn't have admin
privileges, this will trigger the "access denied" error.
<div>
<br>
</div>
<div>Cheers</div>
<div><br>
</div>
</div></div><div>Nicolas<br>
<br>
<div class="gmail_quote">2012/1/13 Bobo Wieland <span dir="ltr"><<a \
href="mailto:bobo@prisjakt.nu" \
target="_blank">bobo@prisjakt.nu</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"><div><div> I'm 100% sure that
the session is correct. I havn't posted the whole chain of
events here, but this is what I've done:<br>
<br>
1. Verified my credentials and got a correct session.<br>
2. Fetched a potential that I know to be assigned to a
group (20x1756).<br>
3a. Tried to change something in the potential and the
update it without changing assigned_to. This causes the
error.<br>
3b. Create a new potential/edit another potential and set
assigned_to to 20x1756. This causes the error (assigning
the potential to a user (19xXXXX) works).<br>
<br>
This is all through the REST api using curl.<br>
<br>
Nicolas Larcipretti skrev 2012-01-13 12:58:
</div></div><div>
<div>
<blockquote type="cite"><div><div>Well, I've never used curl to
do this before, but I think it can be used without
problems.
<div><br>
</div>
<div>Your request seems fine to me, the only things
you need to check are:</div>
<div>- the "sessionName", cause if you create the
token in the wrong way, it won't let you finish
the request.</div>
<div>- the related id's that you're sending.</div>
<div><br>
</div>
<div>Are you shure that your group id is 1756? I
don't know how many users you have, but usualy
that a pretty high number to a group.</div>
<div> <br>
</div>
<div>Can you show us how are you creating your
session?</div>
<div><br>
</div>
<div>Cheers.</div>
<div><br>
</div>
</div></div><div>Nicolas<br>
<br>
<div class="gmail_quote">2012/1/13 Bobo Wieland <span \
dir="ltr"><<a href="mailto:bobo@prisjakt.nu" \
target="_blank">bobo@prisjakt.nu</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"><div><div> Sure.<br>
<br>
Data array:<br>
<pre>[amount] => 0.00
[referenceid] =>
[special_price] => 0
[email] =>
[countrybusiness] => SE
[price_type] => Pricegroup A
[expected_close_date] => 2012-01-09
[created_time] => 2012-01-09 10:53:48
[description] => 120109/SalesBot - Självprofilering
2012-01-09/SalesBot new status.
[modified_time] => 2012-01-13 10:25:50
[next_step] =>
[potential_name] => Featured Store - demo
[type] => Featured Store
[potential_no] => POT3232
[probability_(%)] => 0.00
[related_to] => 3x793
[sales_stage] => Closed Won
[assigned_to] => 20x1756
[potentialid] => 5x53741</pre>
<br>
<br>
This is the raw curl command:<br>
<br>
/usr/bin/curl --header 'Expect:' --header
'Authorization: Basic <CODE>'
--include --url
'<VTIGER_URL>/webservice.php' --data
'element=%7B%22amount%22%3A%220.00%22%2C%22cf_507%22%3A%22%22%2C%22cf_629%22%3A%22 \
0%22%2C%22cf_630%22%3A%22%22%2C%22cf_703%22%3A%22SE%22%2C%22cf_705%22%3A%22Pricegroup+ \
A%22%2C%22closingdate%22%3A%222012-01-09%22%2C%22createdtime%22%3A%222012-01-09+10%3A5 \
3%3A48%22%2C%22description%22%3A%22120109%5C%2FSalesBot+-+Sj%5Cu00e4lvprofilering%5Cn2 \
012-01-09%5C%2FSalesBot+new+status.%5Cn%22%2C%22modifiedtime%22%3A%222012-01-13+10%3A2 \
5%3A50%22%2C%22nextstep%22%3A%22%22%2C%22potentialname%22%3A%22Featured+Store+-+demo%2 \
2%2C%22opportunity_type%22%3A%22Featured+Store%22%2C%22potential_no%22%3A%22POT3232%22 \
%2C%22probability%22%3A%220.00%22%2C%22related_to%22%3A%223x793%22%2C%22sales_stage%22 \
%3A%22Closed+Won%22%2C%22assigned_user_id%22%3A%2220x1756%22%2C%22id%22%3A%225x53741%22%7D&operation=update&sessionName=672515d54f100e7a0cc2e'<br>
<br>
<br>
Nicolas Larcipretti skrev 2012-01-13 11:36:
</div></div><blockquote type="cite">
<div>
<div><div><div>Can you paste here your entire REST
call? I might help you cause I have a
method that does group creation via
webservice here.
<div><br>
</div>
<div>Cheers</div>
<div><br>
</div>
</div></div><div>Nicolas<br>
<br>
<div class="gmail_quote">2012/1/13
Bobo Wieland <span dir="ltr"><<a \
href="mailto:bobo@prisjakt.nu" \
target="_blank">bobo@prisjakt.nu</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 \
0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" \
text="#000000"><div><div> Coming back to this issue. Just ignored it
for a while.<br>
<br>
Trying to set assigned_to for
a potential to "20x1756"
(which is a valid group that
many potentials is assigned to
in our vtiger system) still
gives me the error message:<br>
<br>
"Cannot assign record to the
given user (ACCESS_DENIED)"<br>
<br>
I do this using the REST Web
Services using "update"
<div><br>
<br>
<br>
<br>
praneeth K skrev 2011-10-28
12:51: </div>
</div></div><blockquote type="cite">Hi ,
<div>
<div><div><div><br>
<br>
Generally group id
will be in the format of
'20x<i>groupId</i>'. I
hope you are passing id
to the REST api in the
same format. <br>
<br>
</div></div><div \
class="gmail_quote"><div><div>On Fri, Oct 28, 2011 at
1:51 PM, Bobo Wieland
<span dir="ltr"><<a \
href="mailto:bobo@prisjakt.nu" target="_blank">bobo@prisjakt.nu</a>></span> \
wrote:<br> </div></div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div>Using
the REST-api, is it
possible to set
"assigned_to" for a
Potential<br>
to a Group? I get an
ACCESS_DENIED when I
try even though it
works<br>
perfectly to set it
to a group using the
standard
webinterface.<br>
<br>
best regards<br>
<font color="#888888">Bobo
Wieland - <a \
href="mailto:bobo@prisjakt.nu" target="_blank">bobo@prisjakt.nu</a><br> \
_______________________________________________<br>
</font></div></div><a \
href="http://iger.com/" target="_blank">iger.com/</a></blockquote> </div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote><div>
<br>
<br>
<div>-- <br>
<i>Med vänliga hälsningar<br>
Bobo - <a href="mailto:bobo@prisjakt.nu" \
target="_blank">bobo@prisjakt.nu</a></i></div> </div></div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" \
target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br> \
</blockquote></div><br>
_______________________________________________
http://www.vtiger.com/
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic