topic SharePoint Lists Column Names Not Showing in Workato Pros Discussion Board https://systematic.workato.com/t5/workato-pros-discussion-board/sharepoint-lists-column-names-not-showing/m-p/3081#M1429 <P>Hello. I am trying to search in a SharePoint List and map the response column data pills, but the column datapills doesnt show up in subsequent steps.</P><BR /><P>An alternate way is to use formulas and extract values in how we usually do with hashmaps, but can anyone please help if I am missing any steps? </P><BR /><P></P><BR /><P>I also not able to find any option to select specific columns that will end up being in OData's select query. Did anyone happen to try this out?</P> Mon, 11 Jul 2022 11:27:20 GMT ssrikantam 2022-07-11T11:27:20Z SharePoint Lists Column Names Not Showing https://systematic.workato.com/t5/workato-pros-discussion-board/sharepoint-lists-column-names-not-showing/m-p/3081#M1429 <P>Hello. I am trying to search in a SharePoint List and map the response column data pills, but the column datapills doesnt show up in subsequent steps.</P><BR /><P>An alternate way is to use formulas and extract values in how we usually do with hashmaps, but can anyone please help if I am missing any steps? </P><BR /><P></P><BR /><P>I also not able to find any option to select specific columns that will end up being in OData's select query. Did anyone happen to try this out?</P> Mon, 11 Jul 2022 11:27:20 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/sharepoint-lists-column-names-not-showing/m-p/3081#M1429 ssrikantam 2022-07-11T11:27:20Z Re: SharePoint Lists Column Names Not Showing https://systematic.workato.com/t5/workato-pros-discussion-board/sharepoint-lists-column-names-not-showing/m-p/3082#M1430 <DIV> <DIV> <DIV dir="ltr"> <DIV dir="ltr">Use the http connector and use the Json output in the api result scheme.</DIV> <DIV dir="ltr"><BR /> </DIV> <DIV dir="ltr">Beware that a list returns 5000 items and that you need to paginate.</DIV> </DIV> </DIV> <DIV id="ms-outlook-mobile-signature"> <DIV><BR /> </DIV> Get <A href="https://community.workato.com/links?url=https%3A%2F%2Faka.ms%2Fo0ukef" target="_blank" rel="noopener noreferrer">Outlook for iOS</A></DIV> </DIV> Mon, 11 Jul 2022 14:16:45 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/sharepoint-lists-column-names-not-showing/m-p/3082#M1430 roland-daane 2022-07-11T14:16:45Z