-
That worked!
Now can you explain why?
-
I added the "yes" value, new error.
An error has occurred executing the rule. Failed to add copied rows to destination table.
-
Since the source is elements, I changed the destination back to elements.
Still getting: An error has occurred executing the rule. Failed to select the destination row to copy to.
CopyTable /dsnamesrc=GetListItemsStr /tablesrc=/dfs:myFields/dfs:dataFields/ns2:GetListItemsStrResponse/ns2:GetListItemsStrResult/Rows /rowsrc=row /tabledest=/my:Tasks ...
-
looking back over "Copy SharePoint List Data to Main Data Source" it looks like I need to create the Main fields as attributes. I'm trying that now.
-
Now it looks like the destination syntax is incorrect.
An error has occurred executing the rule. Failed to select the destination row to copy to.
-
Still getting error: An error has occurred executing the rule. Failed to select the source row to copy from.
CopyTable /dsnamesrc=GetListItemsStr /tablesrc=/dfs:myFields/dfs:dataFields/ns2:GetListItemsStrResponse/ns2:GetListItemsStrResult/Rows /rowsrc=dfs:row /tabledest=/my:Tasks /rowdest=my:Task /empty
-
Here is the xpath for my source (sp list) and destination:
Source xpath: /dfs:myFields/dfs:dataFields/ns2:GetListItemsStrResponse/ns2:GetListItemsStrResult/Rows/row
Destination xpath: /my:Tasks/my:Task
Is this the proper syntax for Copy Table?
CopyTable /dsnamesrc=GetListItemsStr ...
-
ok, I figued it out.
2a) create an action to set a fields value for the "query" field under the "queryFields group, use the function icon and set the formula to the concat() string. this replaces the value of this field before you run the second action run the data ...
-
ok, i get that we cannot use the concat() in the data connection, I modified it so the query parameter so it is not using a <filter> argument.
I don't follow on how to configure the button to to return a filtered row set; I am using the GetListItemsStr not the GetDropDownEntries so the step-by-step example is not ...
-
I have successfully used the AD web service to populate my:Tasks/my:UserInfo/my:DisplayName and display it on a form in a text field
I have a button that then run the data connection "GetListItemsStr" to query a SP list.
I used the query builder to create the xml
When I use this query string it return all ...