compumastergmbh / cammutils-vtigernetapi Goto Github PK
View Code? Open in Web Editor NEWLicense: Apache License 2.0
License: Apache License 2.0
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
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
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!
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.