compumastergmbh / cammutils-vtigernetapi Goto Github PK

Hi We're trying to upload an image while creating or updating a product.

We made a new webservice for accepting the upload of the image.
When not actually adding the image ( "application/x-www-form-urlencoded") it runs fine, and make all the neccesarry entries in the database.

But when we actually change the contenttype from "application/x-www-form-urlencoded" to "multipart/form-data" we run into an issue.
This is the error message: "AUTHENTICATION_REQUIRED".

This is the raw post:
POST https://www.mydomain.com/vtigercrm/webservice.php?operation=insert_attachment HTTP/1.1
Content-Type: multipart/form-data; boundary = -----------8d8a1466ac90462
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8
Host: www.mydomain.com
Content-Length: 25689
Expect: 100-continue

-------------8d8a1466ac90462
Content-Disposition: form-data; name="sessionName"

6ec11ae65fd9268f540fd
-------------8d8a1466ac90462
Content-Disposition: form-data; name="id"

14x31
-------------8d8a1466ac90462
Content-Disposition: form-data; name="module"

Products
-------------8d8a1466ac90462
Content-Disposition: form-data; name="imagename[]"; filename="image.jpg"
Content-Type: image/jpeg

image data

This is a non production enviroment so if any testing is needed, it is no problem.
Any help would be appreciated.

I just had one question. When querying a table with more than 100 rows, only 100 rows are returned in the query. Is there a way to fetch the rest of the results or is this something that still needs to be added to the library?

(Partial) copy of codeplex discussion issue already posted at https://vtigernetapi.codeplex.com/discussions/330631

This seems to be the same issue as

#16

as following your example I have tried to retevie a single contact

VTigerContact User = vtigerApi.Retrieve((string)aRow["id"]);

which gets error

{"Error importing JSON String as VTigerApi.Leadsource. ({"success":true,"result":{"salutationtype":"","firstname":"Test","contact_no":"CON15386"

I have tried with a few different datatypes and the same result. It appears the JSON convertors are not functional?

using vTiger v6.2.0
Webservice version 0.22

When trying to create a invoice, can't add items and therefore the invoice can't be create in vTiger.

Error: mandatory fields missing

This means that in order to create a invoice, etc. the record must contents 1 item at least.
We need a way to create invoices, delivery notes, etc. with one or more items.
This does not only affects invoices but also quotations, sales orders, delivery notes, etc

Thank you beforehand

Hi do Vtiger .NET API has any support to custom fields?
thanks in advanced.

Copy of codeplex discussion issue already posted at https://vtigernetapi.codeplex.com/discussions/448219

could you please create a nuget package for your project?

Posted already at https://vtigernetapi.codeplex.com/workitem/list/basic by:
Id #1315 | Release: None | Updated: Feb 23, 2015 at 5:33 PM by mgolisch | Created: Feb 23, 2015 at 5:33 PM by mgolisch

Hi connecting to a vTiger version 6.2.0 works like a charm, but now trying to connect with a vTiger 7.3.0 installation gives the error "
INVALID_AUTH_TOKEN: Specified token is invalid or expired".
It's a brand new installation, it's the API key from the admin user, which is created along with the installation, so expired seems to be unlikely.

Found some other threads about this issue, but none which solves the issue for me.
Any hints to dig deeper in why this is happening?

I'am facing the problem in building a more complex SQL Statement. But how can I do that.

I would like to find a given phone number in the contacts table. The Problem is, that People store their telephone numbers in different formats (most with different using of blanks). That means one telephone number is stored for e.g.

+44 2 22222 222
+4422222 222
+44 222222222
+4422222222

The easiest way to find the number would be to replace all the blanks in the SQL query. The query would be

Select id, REPLACE(phone, ' ', '') from Contacts where phone = '+44 2 22222 222';

But this SQL Statement won't be accepted. The returning error is:

Syntax Error on line 1: token '(' Unexpected PARENOPEN((), expected one of: SELECT

So how can I achieve a select function, where I can find my phonenumber in all contacts with or with no blanks?

Thanks, best regards Perino

Copy of codeplex discussion issue already posted at https://vtigernetapi.codeplex.com/discussions/634856

Hi, I just tested the code submitted in the documentation and had this error: ___An exception of type 'Jayrock.Json.JsonException' occurred in Jayrock.Json.dll but was not handled in user code ...

Posted already at https://vtigernetapi.codeplex.com/workitem/list/basic by:
Id #1290 | Release: None | Updated: Dec 21, 2015 at 3:01 PM by byjuchalad | Created: Jan 6, 2015 at 6:09 PM by Mungle

We need to relate a product to an price book and set a selling price.
Thx in advance

Hi,
I'm testing the demo app against my vTiger v7.1.0 crm. I can log in and the reading functions all work. However, when I try to create a Comment on and Account, I keep on getting the below error:

Post Request:
uri: https://xxx/webservice.php?operation=create
params (Url Encoded): sessionName=1d24c60b614315367ac01&elementType=ModComments&element={"commentcontent":"Test","assigned_user_id":"19x56","createdtime":"2021-09-16T12:06:14.623451+02:00","modifiedtime":"2021-09-16T12:06:14.623451+02:00","related_to":"11x4614","creator":"19x56","parent_comments":null,"id":null,"elementType":24}
params (Clean): sessionName=1d24c60b614315367ac01&elementType=ModComments&element=%7b%22commentcontent%22%3a%22Test%22%2c%22assigned_user_id%22%3a%2219x56%22%2c%22createdtime%22%3a%222021-09-16T12%3a06%3a14.623451%2b02%3a00%22%2c%22modifiedtime%22%3a%222021-09-16T12%3a06%3a14.623451%2b02%3a00%22%2c%22related_to%22%3a%2211x4614%22%2c%22creator%22%3a%2219x56%22%2c%22parent_comments%22%3anull%2c%22id%22%3anull%2c%22elementType%22%3a24%7d

Response:
{"success":false,"error":{"code":"DATABASE_QUERY_ERROR","message":"Database error while performing requested operation"}}

I've asked my db admin to check the db logs and there are no db errors getting logged. I've also asked the infrastructure guys to check our any logs for the crm instance, and so far they could not find any errors either.

Any help or advise will be much appreciated!

The demo sample app can't connect to a vtiger instance with TLS1.2 because .NET support for TLS1.2 starts with v4.7.2, but the sample project targets .NET framework 3.5.

Customs fields can be accessed and listed from all elements, but by creating new elements like accounts or contacts, cant find the custom field to give a value.

Custom fields can be called and updated but not created.

Best Regards
Alvaro A.

This is not working with the current version of vTiger, 6.1. When we compile we get an error, its not working at all. Are you planning on making an update to the source?

Copy of codeplex discussion issue already posted at https://vtigernetapi.codeplex.com/discussions/573016

• Paging might be with size of e.g. 20 records, but now information on max. records in current page
• Total no. of pages not available

I can add new documents and addresses also, but i can't add a new document and assign to any existing address.
How to do?

Hi,
I'm able to add comment to vtiger with modComments but i dont know how to attach file with comment.
can anybody help ?!

Is there any way to upload & attach a document with the API/Web Services that you know of?

(Partial) copy of codeplex discussion issue already posted at https://vtigernetapi.codeplex.com/discussions/330723

Is there a possibility to get the Id of the last inserted Row?

In case of storing a new event I need the new created Id of this event!

Thanks, Perino

Copy of codeplex discussion issue already posted at https://vtigernetapi.codeplex.com/discussions/637966

vTiger 6.5 and up need in order to logout an user a request post and not a request get, otherwise you will be stay logged in at background and obtaing following error message:
{"success":false,"error":{"code":"OPERATION_NOT_SUPPORTED","message":"Permission to perform the operation is denied"}}

Affected project: VTigerApi
Affected file: VTigerService.cs
Line: 334
Content of the error line: String.Format("sessionName={0}", sessionName), false);
Muste be corrected as follow: String.Format("sessionName={0}", sessionName), true);

Hello,
when I try to retrieve a potential I have this error:

The value 'Existing Business' cannot be imported as VTigerApi.Opportunity_type. ({"success":true,"result":{"potentialname":"1 plt da chieri a treviso","potential_no":"TT-2017-849","amount":"74.00000000","related_to":"11x4022","closingdate":"2017-06-16","opportunity_type":"Existing Business","nextstep":"","leadsource":"Direct Mail","sales_stage":"Closed Won","assigned_user_id":"19x7","probability":"0.000","campaignid":"","createdtime":"2017-06-14 14:18:04","modifiedtime":"2017-06-23 10:59:52","modifiedby":"19x10","description":"Riferimento al carico 67708","forecast_amount":"0.00000000","isconvertedfromlead":"0","contact_id":"","cf_751":"riva chieri","cf_753":"10020","cf_755":"to","cf_757":"EMBRACO EUROPE","cf_759":"","cf_763":"","cf_765":"","cf_767":"San Fior","cf_769":"31020","cf_771":"tv","cf_773":"ILSA","cf_775":"","cf_777":"","cf_779":"","cf_781":"merce bancalata","cf_783":"1","cf_785":"870","cf_787":"1 x 120x80x130 + box accessori","cf_791":"non specificato","cf_793":"2017-06-16","cf_795":"2017-06-21","cf_797":"0.00000000","cf_799":"","cf_801":"0.00000000","cf_807":"sky","cf_811":"","cf_813":"","cf_815":"","cf_821":"box accessori piccolo pu\u00f2 essere appoggiato sopra il bancale","cf_823":"","cf_825":"","cf_827":"Italia","cf_829":"Italia","cf_831":"Parziale","cf_833":"","cf_835":"spot","cf_837":"0","cf_839":"0.00","cf_841":"Via Andriano, 12","cf_843":"Via Ferrovia, 31","cf_845":"nessuna","cf_849":"","cf_851":"65.00000000","cf_857":"Piemonte","cf_859":"Veneto","cf_861":"","cf_863":"","cf_865":"","cf_867":"","cf_885":"0","cf_887":"","cf_891":"2017-06-22","cf_893":"2017-06-19","cf_895":"","cf_897":"0","cf_899":"0","cf_901":"spedizione consegnata","cf_903":"","cf_905":"","cf_913":"compressori","cf_938":"","cf_940":"","cf_972":"","cf_980":"","cf_982":"","cf_984":"","id":"13x6957"}})

I don't understand why and can't solve it...
Any help is appreciated

thank you in advanc for the great job you're doing!

• Account
• Asset
• Calendar
• Events
• HelpDesk
• Invoice
• Leads
• PBXManager
• Potentials
• PriceBooks
• Products
• PurchaseOrder
• Quotes
• SalesOrders
• ServiceContracts
• Vendors

attempting to add a salesorder returns missing mandatory field. I'm sure salesorders require a product list, but no place to inter it is in the gui.

Posted already at https://vtigernetapi.codeplex.com/workitem/list/basic by:
Id #1422 | Release: None | Updated: Feb 13, 2016 at 3:03 PM by gwill1010 | Created: Feb 13, 2016 at 3:03 PM by gwill1010