GetListItems not showing all fields

Apr 19, 2013 at 4:59 PM
Hey Marc,
I'm having a bit of a strange situation. I've been using GetListItems to pull from a list. I'm using an external content type list, and it's worked great for 2 other lists in my application. However, now for this third list it's only pulling in 13 of the 19 columns. No idea what's happening. the xData.ResponseXML itself isn't showing those 6 columns. Heard of this happening before? Anything different about external content lists than regular lists?

Here is my list of columns:
Image

Here are the 6 column names it's not pulling in (in case it sheds any light):
  • Suffix
  • Office
  • PassportNo
  • PassportExpire
  • VisaNo
  • VisaExpire
Hopefully this discussion isn't too specific. Just seems weird. Been banging my head against the wall for an hour or so trying to figure out why...
Ben
Apr 19, 2013 at 5:01 PM
Sorry. Ignore. I'm an idiot. Columns are empty :)
Coordinator
Apr 20, 2013 at 2:05 PM
Ben:

It should make you feel better to know that I struggled with exactly this on Thursday as I was building a demo to show async vs. promises with the new version of SPServices. Either you're not an idiot or we both are!

M.
Apr 21, 2013 at 9:59 PM

Seems so simple, right?! I never think to check the simple things like “oh, SharePoint’s not giving me data because, well, I didn’t give SharePoint any data in the first place.”