web query office 95

convict source llc 1 Reputation point
2021-09-11T03:28:35.743+00:00

so i go here https://docpub.state.or.us/OOS/intro.jsf

hit accept

then i am on this screen

https://docpub.state.or.us/OOS/intro.jsf;jsessionid=A2A1944E0799AC4A7220D302EC89352E.wrkr-DP1-Blue

when i type into any of the fields and find the person im lookin for i want to pull the resulting data to my excel sheet and filter out what i dont need

example

Luray batterton Sid # 10018434

131243-oregon-offender-search.pdf

i dont need the charges but i would like all the above information

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,641 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Miguel Escobar 326 Reputation points
    2021-09-18T04:34:06.517+00:00

    Hey @convict source llc !

    I see that you've used the tag "power-query-online", but you don't mention any of the Power Query Online instances (usually dataflows).

    Could you please tell us more about your scenario? What tool / product are you using or trying to use in Excel to accomplish this?

    How can we help? What specific questions do you have?

    0 comments
  2. convict source llc 1 Reputation point
    2021-09-18T08:57:30.69+00:00

    I'm trying to build a query based on parameters in the excel workbook
    But I struggle to determine what I need to pull this data I tried import xml on Google sheets I tried webservice on excel 2013 I tried Microsoft access I would like to be able to type a number in choose a website and have it return name location and picture into my excel worksheet I though power query might be able to do it but I've never used it am trying to figure it out. All my source reference in the original post

  3. Emily Hua-MSFT 27,526 Reputation points
    2021-09-20T09:50:45.96+00:00

    @convict source llc

    I would suggest you download the PDF files and use some tools to convert these files to Excel workbooks.

    If you import the data to Power Query in Excel 2013 (DATA > From Web), we could get the results list. There are no hyperlinks for each SID number.
    133594-untitled.png
    133555-untitled2.png

    But if you want to get the information of one specific SID number, the query would retun no data.
    133537-image.png

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  4. convict source llc 1 Reputation point
    2021-09-23T03:41:06.72+00:00

    ok well what if i use

    https://vinelink.com/classic/#/search

    to look them up there is no accept issue and could return a hyper link for location?

    i found and used a macro to import the image based on a url but still need to return location from a webpage like the one about based on a cell defined in the excel table see attached workbook