Forum > RSS Feed
Community Login
Infusionsoft Community
Welcome, Guest
Please Login or Register.    Lost Password?
Re:Retrieving ALL fields using DS.Load or DS.Query (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Retrieving ALL fields using DS.Load or DS.Query
#8413
mmdurrant (User)
Junior Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Retrieving ALL fields using DS.Load or DS.Query 2 Weeks, 2 Days ago Karma: 0  
Is there a way to retrieve ALL fields in a DataService.Load or DataService.Query operation without knowing all of the field names? I tried passing an array containing a single element "*" for the fields parameter and got nothing.
 
Report to moderator   Logged Logged  
 
Last Edit: 2009/11/04 18:07 By mmdurrant.
  The administrator has disabled public write access.
#8415
techportal (User)
CMAC
Posts: 226
graphgraph
User Online Now Click here to see the profile of this user
Re:Retrieving ALL fields using DS.Load or DS.Query 2 Weeks, 2 Days ago Karma: 7  
No, I'm afraid the "*" only works in standard SQL situations. The API doesn't take it.

You only bet is to create the full array of return fields:

Code: :

 array('AccountId''Address1Type''Address2Street1''Address2Street2''Address2Type''Address3Street1''Address3Street2''Address3Type''Anniversary''AssistantName''AssistantPhone''BillingInformation''Birthday''City''City2''City3''Company''CompanyID''ContactNotes''ContactType''Country''Country2''Country3''CreatedBy''DateCreated''Email''EmailAddress2''EmailAddress3''Fax1''Fax1Type''Fax2''Fax2Type''FirstName''Groups''HTMLSignature''Id''JobTitle''LastName''LastUpdated''LastUpdatedBy''Leadsource''MiddleName''Nickname''OwnerID''Password''Phone1''Phone1Ext''Phone1Type''Phone2''Phone2Ext''Phone2Type''Phone3''Phone3Ext''Phone3Type''Phone4''Phone4Ext''Phone4Type''Phone5''Phone5Ext''Phone5Type''PostalCode''PostalCode2''PostalCode3''ReferralCode''Signature''SpouseName''State''State2''State3''StreetAddress1''StreetAddress2''Suffix''Title''Username''Website''ZipFour1''ZipFour2''ZipFour3');



Best,
Bob
 
Report to moderator   Logged Logged  
 
Bob Keen
https://www.InfusionWP.com - TurboCharge InfusionSoft with WordPress Membership Sites!

http://www.infusionsoftkunaki.com - Full Kunaki/Infusionsoft Gateway Solution

http://infusionsoft1clickupsell.com/ - Don't miss a launch and don't lose a single sale
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop