cancel
Showing results for 
Search instead for 
Did you mean: 
mark_spelbring
Nintex Newbie

In Workflow 2007 using the Query List action I'm trying to use workflow constants for the Site URL and in my CAML query I'm trying to use a workflow constant for the List ID. This is so I can develop in one environment and import into another. I receive t

Jump to solution

In Workflow 2007 using the Query List action I'm trying to use workflow constants for the Site URL and in my CAML query I'm trying to use a workflow constant for the List ID. This is so I can develop in one environment and import into another. I receive the error  "Failed to query list data. Data at the root level is invalid. Line 1, position 1.". If I hardcode the workflow constant values in the Site URL and CAML query for List ID all works as expected. Should I be able to use the workflow constants in the Query List action?

Labels: (1)
0 Kudos
Reply
5 Replies
murphybp2
Nintex Newbie

Re: In Workflow 2007 using the Query List action I'm trying to use workflow constants for the Site URL and in my CAML query I'm trying to use a workflow constant for the List ID. This is so I can develop in one environment and import into another. I recei

Jump to solution

When you used the List ID Constant, did you put quotes around it?  Like this:

<List ID="{Common:ListID}"/>

If you didn't, you'll get an error.

0 Kudos
Reply
mark_spelbring
Nintex Newbie

Re: In Workflow 2007 using the Query List action I'm trying to use workflow constants for the Site URL and in my CAML query I'm trying to use a workflow constant for the List ID. This is so I can develop in one environment and import into another. I recei

Jump to solution

Brendan,

Thanks for the reply. Yes...I put quotes around the constant.

0 Kudos
Reply
murphybp2
Nintex Newbie

Re: In Workflow 2007 using the Query List action I'm trying to use workflow constants for the Site URL and in my CAML query I'm trying to use a workflow constant for the List ID. This is so I can develop in one environment and import into another. I recei

Jump to solution

And it's still failing?  Can you provide a screen shot of your query list setup then with the CAML?

0 Kudos
Reply
mark_spelbring
Nintex Newbie

Re: In Workflow 2007 using the Query List action I'm trying to use workflow constants for the Site URL and in my CAML query I'm trying to use a workflow constant for the List ID. This is so I can develop in one environment and import into another. I recei

Jump to solution

Not sure why but it now working. I did have a Web Service action after the Query List action that was not working but did not generate an error. I removed the Web Service action and now the Query List action is working.

 

Again - thanks for the reply.

View solution in original post

0 Kudos
Reply
murphybp2
Nintex Newbie

Re: In Workflow 2007 using the Query List action I'm trying to use workflow constants for the Site URL and in my CAML query I'm trying to use a workflow constant for the List ID. This is so I can develop in one environment and import into another. I recei

Jump to solution

No problem.  Glad it's working.

0 Kudos
Reply