Simple Restful Service

  • Durum: Closed
  • Ödül: $51
  • Alınan Girdiler: 2
  • Kazanan: jagdishidhate

Yarışma Özeti

I have 3 files that need to be converted into RESTFul Services on the Fly.

Employee Contacts, Employee preferences, Employee Pictures etc.

I have each of these in a separate format CSV, MySQL Format and Pipe delimited file format respectively.

These need to served as REST services identified by a key

So..
Employee Contact: [login to view URL] will get me all the details about employee with ID - 12345
Employee Preference: [login to view URL] will get me all the details about employee preference with ID - 12345
Employee Picture: [login to view URL] will get me all the employee picture of employee with ID - 12345

This service needs to be created for any of these files. i.e. I can change the file at any time.
Also - Deploy this to amazon Cloud. I will give you userid and password.

Please contact me if you have questions....

Sample Flow:
Lets Say you have a file "[login to view URL]" with 5 columns. (name, ssn, age, city, zip).
We need to create a Rest service out of this.
So - Select the file to create upload. ([login to view URL] in this case)

Select the REST search fileds. Say i want 2 fields - ssn and zip.
So i add thes in the search-Id.

And hit the create button.

Now i have a service that accepts/
...localhost:8080/data-service/key/emp-data/ssn/123456789/zip/20144



TESTING:
1. "[login to view URL]" - This is the page that will allow me to select the CSV or JSON or XML file as the source into the system.
CSV needs to have headers. (a check must be done). XML has element name. JSON file will have name-value pair.
For each of these IDs - we can mention the ones that are allowed to be search IDs.

e.g. if i Select "FirstName" as the SearchID. I should be able to call the service with "firstname" as SearchID. However, "LastName" should fail.

2. The sample CSV file has been attached. There can be different CSV file that i can decide to load. If I decide to load a new CSV but use same KEY (emp-contact) then the existing data in the DB should be truncated and loaded with the the new CSV's Data.

Tavsiye Edilen Beceriler

Bu yarışmadan başlıca girdiler

Daha Fazla Katılım Görüntüle

Genel Açıklama Panosu

  • abhijitcaps
    abhijitcaps
    • 2 yıl önce

    Can i join in now ? or the contest is over...

    • 2 yıl önce
    1. abhijitcaps
      abhijitcaps
      • 2 yıl önce

      Thanks...

      • 2 yıl önce
    2. abhijitcaps
      abhijitcaps
      • 2 yıl önce

      I am not able to download the requirement...Can you help me with it. Sorry, I am probably taking your time.

      • 2 yıl önce
  • seryozhahovhan
    seryozhahovhan
    • 2 yıl önce

    So, As I Understand:-
    1) There can be different data types .sql, csv, json etc
    2) The incoming data can have different structure(column names is undefined)
    3) The restfull service must toconvert and find out the row from incoming file data

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      Yep. The Rest services will know this when the file is getting uploaded.

      • 2 yıl önce
  • jagdishidhate
    jagdishidhate
    • 2 yıl önce

    In "rest.html"
    1. Is "Add" button will upload json/xml/csv to database?
    2. What "Create Service" will do?, Is it for searching?

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      Lets Say you have a file "data.csv" with 5 columns. (name, ssn, age, city, zip).
      We need to create a Rest service out of this.
      So - Select the file to create upload. (data.csv in this case)

      Select the REST search fileds. Say i want 2 fields - ssn and zip.
      So i add thes in the search-Id.

      And hit the create button.

      Now i have a service that accepts/
      ...localhost:8080/data-service/key/emp-data/ssn/123456789/zip/20144

      • 2 yıl önce
  • seryozhahovhan
    seryozhahovhan
    • 2 yıl önce

    how can I apply this

    • 2 yıl önce
  • joemathewsl
    Yarışma Sahibi
    • 2 yıl önce

    There is just one CSV attached. The solution should allow any number of CSVs and of different structures to be used.

    • 2 yıl önce
  • abuehtesham
    abuehtesham
    • 2 yıl önce

    Or do you want me to create tables myslf. Can do dat as well.

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      I would recommend you think beyond table. This will need objects to be stored. So NoSQL like Mongo will be better suited.

      • 2 yıl önce
    2. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      You may do it with whatever approach you want - But keep in mind.. Schema is variable.

      • 2 yıl önce
  • farhanshaikh02
    farhanshaikh02
    • 2 yıl önce

    Hi, can you please through some light on the structure of the images arranged & is it a csv file?

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      Sample CSV files attached.

      • 2 yıl önce
  • radientparadise4
    radientparadise4
    • 2 yıl önce

    also please share example files, will you be adding more fields to these files or the fields are fixed and will never change

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      Sample CSV files attached. Please keep in mind that there can be different CSV files that can be used. And the files used will need to be served as REST.

      • 2 yıl önce
  • strider196
    strider196
    • 2 yıl önce

    Hey Joe,

    Do you have some example data I could use to build the app?

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      I will provide some sample data soon. Stay tuned...

      • 2 yıl önce
    2. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      sampleCSV files attached.

      • 2 yıl önce
  • Elyasin
    Elyasin
    • 2 yıl önce

    Hi there, it would be helpful to have sample files in order to be more efficient in developing your requirements; could make deployment faster. MySQL format is not precise enough, is it a file in a specific format (What is the ending of the file? Or how is the content structured?) or is it a MySQL database?
    I suggest to import the file contents into a database and maintain data there: It is more efficient in terms of speed, easier to maintain and less error prone.

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      CSV files attached.

      • 2 yıl önce
    2. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      There can be different CSV files - with different schema's that get used.

      • 2 yıl önce
  • abusyahid
    abusyahid
    • 2 yıl önce

    Hi Mate, i need your attachment scheme database, so i could do some test.

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      There is no fixed schema

      • 2 yıl önce
    2. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      Schema can be different.

      • 2 yıl önce
  • anjaiahspr
    anjaiahspr
    • 2 yıl önce

    HI ,Plz share attached scheme database ,plz contact me anjaiahspr@gmail.com

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      CSV files attached.

      • 2 yıl önce
  • shineconsul
    shineconsul
    • 2 yıl önce

    PLease confirm if format of individual file going to remain same all the time...but u can change the content of the file at any time ... u want an ability where without restarting ur web container, service should pick up the new content.

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      CSV files attached.

      • 2 yıl önce
    2. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      Yes - update without restarting.

      • 2 yıl önce
  • abuehtesham
    abuehtesham
    • 2 yıl önce

    My Understanding:-
    1.) You want to dump database details to CSV file and returns CSV file as contacts response.
    2.) You want mySQL script as response for employee preference.
    3.) You want picture file (JPG..etc) as response for Employee Pictures

    Now could you please share mySQL db script so that we get idea of table structures.

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      1. YES

      • 2 yıl önce
    2. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      2 and 3 also YES

      • 2 yıl önce
  • radientparadise4
    radientparadise4
    • 2 yıl önce

    are you ok if number of records you can have in these files is limited to amount java heap we configure on the amazon box? or you want a db to be hosted on same machine which gets synced with file changes?

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      Sure - Lets limit the POC to 10K.

      • 2 yıl önce
    2. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      10K rows.

      • 2 yıl önce
  • radientparadise4
    radientparadise4
    • 2 yıl önce

    do you want live reloading of modified files?

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      YES

      • 2 yıl önce
  • shineconsul
    shineconsul
    • 2 yıl önce

    Also, what did you mean my Mysql Format?

    • 2 yıl önce
    1. joemathewsl
      Yarışma Sahibi
      • 2 yıl önce

      If you run the mysql - export or dump command it creates a file. The idea to to load the file of that format. But I will post a sample file for you soon.

      • 2 yıl önce
  • abuehtesham
    abuehtesham
    • 2 yıl önce

    I have questions:-

    • 2 yıl önce

Daha fazla yorum göster

Yarışmalara nasıl başlanır

  • Projenizi ilan edin

    Yarışmanızı İlan Edin Hızlı ve kolay

  • Tonlarca girdi alın

    Tonlarca Girdi Alın Bütün dünyadan

  • En iyi girdiyi seçin

    En iyi girdiyi seçin Dosyaları indirin - Kolay!

Şimdi bir Yarışma İlan Et ya da Bugün Bize Katılın!