Comments (11)
That fault is coming back from Infusionsoft. This means something is causing the database query to error out. With findByEmail you pass in a second parameter of the fields you want returned, I've seen where some fields will randomly error out. Can you provide me more information on this and I can dig in from Infusionsoft's side to see if I can find anything?
If you can provide me your appname and an email address that this is happening on i can take a look. You can email it to me if you would prefer not to post it on here. [email protected]
from infusionsoft.net.
Thanks for looking at this. I sent those details to [email protected].
If there's a better approach to using the API, I'm open to that. Is using the table service with known column names less error-prone, maybe?
from infusionsoft.net.
I think you have to include the columns that you want in return.
//Find contacts dotnet styleconst string email =
"[email protected]";var contact =
client.ContactService.FindByEmail(email, p => p.Include(c => c.Id)
.Include(c => c.Email));
or
var contact = client.ContactService.FindByEmail(email, p => p.IncludeAll());
Scott Cate
Cell: 602-418-0770
Office: 714-64-EVENT
Fax: 480-304-3023
Follow us on ...
www.facebook.com/EventDay
www.twitter.com/EventDay
*Try EventDay: *Setup your Free Event in 30 Seconds
http://evn.tc/EventDay_Free
On Fri, Mar 7, 2014 at 8:29 AM, piranout [email protected] wrote:
Thanks for looking at this. I sent those details to [email protected].
If there's a better approach to using the API, I'm open to that. Is using
the table service with known column names less error-prone, maybe?Reply to this email directly or view it on GitHubhttps://github.com//issues/18#issuecomment-37034170
.
from infusionsoft.net.
If you pass in an empty array for the return fields, it will return the Id only. If you don't even pass in the second parameter, it will return this error: "No method matching arguments: java.lang.String, java.lang.String, java.lang.String".
I think this may be related to something else since he's getting a Database error.
from infusionsoft.net.
could be a mismatch on the apikey, or connection somehow. the error
returned isn't also pointing to the actual problem.
i would try the code samples, just to see if it starts working.
Scott Cate
Cell: 602-418-0770
Office: 714-64-EVENT
Fax: 480-304-3023
Follow us on ...
www.facebook.com/EventDay
www.twitter.com/EventDay
*Try EventDay: *Setup your Free Event in 30 Seconds
http://evn.tc/EventDay_Free
On Fri, Mar 7, 2014 at 8:38 AM, Michael Fairchild
[email protected]:
If you pass in an empty array for the return fields, it will return the Id
only. If you don't even pass in the second parameter, it will return this
error: "No method matching arguments: java.lang.String, java.lang.String,
java.lang.String".I think this may be related to something else since he's getting a
Database error.Reply to this email directly or view it on GitHubhttps://github.com//issues/18#issuecomment-37035037
.
from infusionsoft.net.
I think it might be related to "AccountId" column being asked for. Thats the only field I was able to get this error to throw on.
from infusionsoft.net.
The .IncludeAll() construct throws the same database error as the one-parameter .FindByEmail overload call did.
This manual projection works, even with AccountId included. However, it always returns 0 for the AccountId:
var contact = client.ContactService.FindByEmail(
email, projection => projection
.Include(c => c.Id)
.Include(c => c.Company)
.Include(c => c.FirstName)
.Include(c => c.LastName)
.Include(c => c.Email)
.Include(c => c.State)
.Include(c => c.PostalCode)
.Include(c => c.Phone1)).FirstOrDefault();
Still, this is progress.
from infusionsoft.net.
FWIW, we found that the include all will error, and that has something to
do with custom fields.
maybe a custom field is null? or missing on a record? i'm not sure, but
this may help solve the Error.
please keep in touch, i'm interested to see what you find.
Scott Cate
Cell: 602-418-0770
Office: 714-64-EVENT
Fax: 480-304-3023
Follow us on ...
www.facebook.com/EventDay
www.twitter.com/EventDay
*Try EventDay: *Setup your Free Event in 30 Seconds
http://evn.tc/EventDay_Free
On Fri, Mar 7, 2014 at 9:33 AM, piranout [email protected] wrote:
The .IncludeAll() construct throws the same database error as the
one-parameter .FindByEmail overload call did.This manual projection works, even with AccountId included. However, it
always returns 0 for the AccountId:var contact = client.ContactService.FindByEmail(
email, projection => projection
.Include(c => c.Id)
.Include(c => c.Company)
.Include(c => c.FirstName)
.Include(c => c.LastName)
.Include(c => c.Email)
.Include(c => c.State)
.Include(c => c.PostalCode)
.Include(c => c.Phone1)).FirstOrDefault();Still, this is progress. [image:
👍 ]Reply to this email directly or view it on GitHubhttps://github.com//issues/18#issuecomment-37040890
.
from infusionsoft.net.
Well, adding contact.AccountId
to the .Include()
calls made the Database Error return.
Could it be that there are nullable fields in the database mapped to non-nullable types in the .NET client? Or is this strictly a SQL query error on the server side?
from infusionsoft.net.
This is an error on our side. AccountId is mapped to CompanyId but thats for the DataService so that might be why this is happening. I will send up a ticket to development on this.
from infusionsoft.net.
Don't know if this is helpful at all, but including .CompanyId gets past the error, but returns 0. (Saying "AccountId" worked in my earlier comment was a typo #18 (comment))
from infusionsoft.net.
Related Issues (20)
- OAuth HOT 2
- Using DataService.Query<Table>(page, queryBuilder,fieldSelection) with dates in queryBuilder returns no results. HOT 4
- DataService.Count HOT 3
- RecurringOrderWithContact field HTMLSignature preventing Query<RecurringOrderWithContact>(..)
- Issue calling FileService.UploadFile HOT 8
- ContactService.AddToCampaign {"Server returned a fault exception: [6] [Loading]Error loading follow-up sequence"} HOT 1
- Create Tag/ Get all Tag / Get Tag by Name HOT 2
- .Net Helper Library for REST api support
- Question: What is the "application" value expected? HOT 1
- Error on .Update = A parameter is of, or contains an instance of, type System.Collections.Generic.Dictionary... which cannot be mapped to an XML-RPC type HOT 3
- Unable to get the InfusionSoft project to work in VS2013 HOT 1
- InfusionSoftException when using FindByEmail and IncludeAll
- Hello
- Cannot retrieve custom fields with api call. HOT 1
- Query by Ids
- API ChargeInvoice response contains implicit string value where integer expected HOT 3
- Doesn't work with .net core HOT 2
- New .NET Infusionsoft Client
- TLS 1.2 HOT 9
- How can i create a custom field for Contact? HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from infusionsoft.net.