question

convictsourcellc-6173 avatar image
0 Votes"
convictsourcellc-6173 asked emilyhua-msft commented

web query office 95

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


office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MiguelEscobar-3907 avatar image
0 Votes"
MiguelEscobar-3907 answered

Hey @convictsourcellc-6173 !

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

convictsourcellc-6173 avatar image
0 Votes"
convictsourcellc-6173 answered MiguelEscobar-3907 commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Unfortunately, the webpage doesn't appear to be a good fit for Power Query in Excel. Primarily because the webpage has a mechanism that requires the user to "Accept" an agreement before loading the page that you might be interested in.
I'm changing your tag to be related to Excel hoping that any Excel experts could give you any other suggestions.

0 Votes 0 ·
emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

@convictsourcellc-6173

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.


untitled.png (51.1 KiB)
untitled2.png (79.4 KiB)
image.png (34.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

convictsourcellc-6173 avatar image
0 Votes"
convictsourcellc-6173 answered emilyhua-msft commented

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




[1]: https://onedrive.live.com/edit.aspx?cid=3867bb68a1860c88&page=view&resid=3867BB68A1860C88!114&parId=3867BB68A1860C88!103&app=Excel

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@convictsourcellc-6173
I tried to create a query for this link "https://vinelink.com/classic/#/search", but there is no luky.
This link could only be opened via IE in Compatibility View.

IBesides, as tag "office-excel-itpro" focus on general issues of Excel client, if you have the questions on macro code that you found, it's recommneded to add a tag "office-vba-dev".
Thanks for your understanding.


0 Votes 0 ·