Hi,
I have two SharePoint lists residing on different sites. I need to copy items from a particular column from Site A list to Site B list based on unique identifier (same on both lists). I tried to query A list with CALM editor but getting error “Failed to query list data. The Web application at https:://…./Sites/Site Name could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add….” (I am sure I use correct URL). Is there any other way to do that? what could be wrong with with “Site URL not found”? Many thanks in advance for your help!