When I search through a Sharepoint list, Workato does find the record I'm looking for, but I can't access the column values. In the search I have IM_Item eq 'ProjectSetup' and it does reteieve that record. I can't get the values of the columns Project, Originator, Volume, Levels, Informationtypes or ProjectRoles
What do I need to do to access the columns? (Each string is to go into a variable).
Roland Daane
Searching through Sharepoint list
When I search through a Sharepoint list, Workato does find the record I'm looking for, but I can't access the column values. In the search I have IM_Item eq 'ProjectSetup' and it does reteieve that record.
I can't get the values of the columns Project, Originator, Volume, Levels, Informationtypes or ProjectRoles
What do I need to do to access the columns? (Each string is to go into a variable).
Job output:
IM_Item: ProjectSetup,
Project: BC1234,
Originator: ECS,
Volume: ZZ,XX,00,01,02,03,
Levels: ZZ,XX,GF,00,01,02,M1,M2,B1,B2,
InformationTypes: AF,AG,BQ,CA,CC,CE,CH,CM,CO,CR,DR,ER,ES,FE,GD,IE,IM,IS,IV,LT,M2,M3,MA,MO,MI,MR,MS,PH,PL,PP,PR,PT,PW,PY,QE,RD,RG,RI,RP,SB,SH,SK,SN,SP,SU,TE,VR,
ProjectRoles: A,B,C,D,E,F,G,H,I,K,L,M,P,Q,S,T,W,X,Y,Z,