SharePoint Integration

Re: RefreshSharePointListItems problem

awilliam0815 — Fri, 24 Oct 2014 16:48:57 GMT

I think I found the problem . . ..there were some fields missing in the SharePoint list VIEW that I based my owssvr query on. I added the fields, and the repeating table is now updating. Thanks for your assistance!

Re: RefreshSharePointListItems problem

Hilary Stoupa — Fri, 24 Oct 2014 16:39:46 GMT

The updates are based on the qRulesLastModified date compared to the last modified date in the list. When are you running the refresh command?

Re: RefreshSharePointListItems problem

awilliam0815 — Fri, 24 Oct 2014 16:34:54 GMT

Here is the command that I used:

RefreshSharePointListItems /dsname=owssvr-task50 /mapping=mappingTASKrepeating20 /mode=Update

I am still not able to see any updates in my repeating table.

Re: RefreshSharePointListItems problem

Hilary Stoupa — Fri, 24 Oct 2014 16:27:23 GMT

You are doing great - there is a /mode parameter on the command. By default, we don't overwrite your data. But it sounds like with your refresh command, all items matched?

Re: RefreshSharePointListItems problem

awilliam0815 — Fri, 24 Oct 2014 16:19:27 GMT

Okay . .I changed the dsname parameter to an owssvr query and eliminated the error, and recieved confirmation message 'Report for mapping: task50. All items match.' I noticed that my repeating table fields did not update . .. .is there an additional step that needs to be complete to update the repeating table content in my filler form? Sorry for such basic question! Thanks.

Re: RefreshSharePointListItems problem

Hilary Stoupa — Fri, 24 Oct 2014 15:30:00 GMT

The refresh command uses an owssvr (XML File) data connection, not the same lists submit data connection you use for your SharePoint submit.

This is from 4.2, but the basic idea hasn't changed much: http://www.infopathdev.com/blogs/hilary/archive/2012/07/05/qrules-refreshsharepointlistitems-walkthrough-for-v4-2.aspx

RefreshSharePointListItems problem

awilliam0815 — Fri, 24 Oct 2014 15:20:28 GMT

I am using qRules command RefreshSharePointListItems to updated items from my infopath filler form to a SharePoint list, and am getting the following error:

Failed to refresh list items: Unable to cast object of type 'Microsoft.Office.InfoPath.Internal.SharePointListAdapterRWQueryAdapterHost' to type 'Microsoft.Office.InfoPath.FileQueryConnection'.

I am able to use the SubmitToSharePointList command with the same dsname and mapping without any errors.

Do you have any ideas on why I might be getting this error?

Thanks