Finalizat

Create a VB Excel Script for pulling OMDBAPI metadata

I have an Excel spreadsheet with a list of movies and tv shows. I have a script that will connect to [login to view URL] and pull meta information for movies based on the content in Cell A. The problem is, the script is unable to pull metadata for TV shows, and it also has some trouble with the titles and sometimes does not recognize it if the text isn't perfect.

Here is a sample of some of the titles.

28 Weeks Later

2 Guns 2013

30,000 Leagues Under The Sea 2007

300[2006]

300 Rise of an Empire 2014

30 Minutes Or Less 2011

30 Rock S01E01 Pilot

30 Rock S01E02 The Aftermath

What I need is the script modified so that it IF the title contains season and episode information it instead searches omdbapi using that information transposed from the title into something omdbapi can recognize.

I don't know the syntax but it would logically be something like:

IF title contains "s##*e##" then use "t=%s&season=%s&episode=%s" instead of searching by title only.

Here is a sample of a way to connect to the omdbapi for episode and season information.

"String url = "[login to view URL]";

String charset = "UTF-8";

String title = "Game of Thrones";

String season = "5";

String episode "5";

String query = [login to view URL]("t=%s&season=%s&episode=%s",

[login to view URL](title, charset),

[login to view URL](season, charset),

[login to view URL](episode, charset),);

URLConnection connection = new URL(url + "?" + query).openConnection();

[login to view URL]("Accept-Charset", charset);

InputStream response = [login to view URL]();

// Do some stuff with the data"

Aptitudini: Introducere date, Procesare date, Excel, Visual Basic, Web Scraping

Vezi mai multe: official imdb api, omdb api key free, how to use omdb api javascript, using excel and vba to get api data, omdb api python, how to use omdb api, omdb api documentation, imdb api php, excel script copy cell data closed file, processing data excel script, script create folders excel, script create account excel windows, excel script active directory user create, create sheets excel column data vba, script create reports excel, excel script update data connection, power shell script active directory create users excel, paste data excel script, excel script import data, vba excel script import data web

Despre angajator:
( 0 recenzii ) Jefferson, United States

ID Proiect: #17999352

Acordat lui:

Grunty

Hi there, I understood the problem and can come up with an 'elegant' (efficient + simple) solution. Looking forward to your contact, Grunty.

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 4 zile
(44 Recenzii)
5.6

10 freelanceri licitează în medie 49$ pentru acest proiect

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(641 recenzii)
8.3
schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Create a VB Excel Script for pulling OMDBAPI metadata. I've delivered more than 400 + projects in the last 5 years and this makes Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(303 recenzii)
7.7
webanis

Hi, I am interested in your offer. Let me know more details about this work. I will start working immediately :) Br;

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(18 recenzii)
4.1
dataexplorer

Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional work Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(17 recenzii)
3.5
webscraper24

"Greetings! According to your stated project description you need an excel exper. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(1 părere)
0.0
rahuls5132

I've been working in working with .Net Framework and Microsoft products and services for the past few years. I am trained in design and development of Microsoft Office Add-in using VSTO framework C#. As per your requir Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
covin

I have extensive experience using Excel in my past work. As a Statistics TA that used Excel to manage to manipulate and analyze data, I already have an idea of what needs done. Although it seems that you might have som Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
Sunnyraph

I have an Excel spreadsheet with a list of movies and tv shows. I have a script that will connect to [login to view URL] and pull meta information for movies based on the content in Cell A. The problem is, the script is unable Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
kishorsaundane

I have 5 years of experience in excel vba webscraping also i offer you sample of the data.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0