I have successfully been able to pull data from a SharePoint list via a WebFocus connection.

I am wondering if there is a way to modify the list items through WebFocus.

Ultimately I want to run a procedure in Webfocus and update the list items in a SharePoint list with that data.

This message has been edited. Last edited by: <Kathryn Henning>,

Do you meant to ask, update the datas in DB when you run a fex?

Yes I would like to update the data when I run a fex.

The data source for the MFD is a SharePoint list. This is what I tried.

LOC_MAS is a MFD that is connected to a SharePoint list. Do I need to do something different because of the type of connection?

JOIN BUSENTITY IN ZOH_REFXM2 TO ALL BUSENTITY IN ZOH_REFXM1 TAG M1 AS J01
END
TABLE FILE ZOH_REFXM2
PRINT
LOCATION
BUSENTITY
TXTLG
PZBETYPE
PZRERGION
PZREGROUP
PZREDISTRICT
ZNIEGH2
REGION
ZREPROTO
ZRELREMDT
ON TABLE HOLD
END
DEFINE FILE ZOH_REFXM2 CLEAR
END

JOIN CLEAR *

MODIFY FILE LOC_MAS
FIXFORM FROM HOLD
MATCH BUSENTITY
ON MATCH UPDATE LOCATION TXTLG PZBETYPE PZRERGION PZREGROUP PZREDISTRICT ZNIEGH2 REGION ZREPROTO ZRELREMDT
ON MATCH SQL COMMIT WORK
ON NOMATCH INCLUDE
ON NOMATCH SQL COMMIT WORK
DATA ON HOLD
END