[Product] 'API' has been assigned to katelyn.rogers

Fri Nov 8 06:46:03 UTC 2013

Hi Darren,

Just found your message on the mailing list.

For your information, we have, at OpenDataSoft, worked a bit with the POD database. See http://pod.opendatasoft.com.

As you can see, we have created datasets out of the original database (that we constantly update to reflect fast changing POD database content).

Here they are: 
- GTIN Codes (joined with GLN, brands and groups information): http://pod.opendatasoft.com/explore/dataset/pod_gtin/#?tab=table
- GCP Codes (joined with GLN information): http://pod.opendatasoft.com/explore/dataset/pod_gcp/#?tab=table
- Brands: http://pod.opendatasoft.com/explore/dataset/pod_brand/#?tab=table
- GTIN Codes with nutrition information (joined with GLN, brands and groups information): http://pod.opendatasoft.com/explore/dataset/pod_nutrition_us/#?tab=table

Our approach is search based. Every dataset comes with its exploration console and the corresponding API. Anything you can do with the UI, you can also do it with the APIs.

Here are a few examples with the main GTIN dataset (pod_gtin):
- To retrieve the description of the dataset (and the list of available fields for querying): http://pod.opendatasoft.com/api/datasets/1.0/pod_gtin
- To search for GTIN codes containing the word "Cola" in one of their textual fields: http://pod.opendatasoft.com/api/records/1.0/search?dataset=pod_gtin&q=cola&facet=gpc_s_nm&facet=brand_nm&facet=group_nm&facet=gln_nm&facet=prefix_nm
- To search for GTIN codes whose package weights more than 100 oz: http://pod.opendatasoft.com/api/records/1.0/search?dataset=pod_gtin&q=m_oz+%3E+100&facet=gpc_s_nm&facet=brand_nm&facet=group_nm&facet=gln_nm&facet=prefix_nm

When using the data exploration console, you can switch to the API tab to understand how you can perform similar using the API: http://pod.opendatasoft.com/explore/dataset/pod_gtin/#?tab=api&q=m_oz%20%3E%20100

The API also has aggregation and analytics capabilities. We are currently fixing the documentation …

Of course, this API is and will stay free of use.

Do not hesitate to come back to me if you have any question, comments and feedbacks you would like to share.

With my best regards,

--
Bien cordialement, / Best Regards,

David Thoumas
Chief Technical Officer, OpenDataSoft
+33 (0)6 77 52 35 22
@thoumasd / @opendatasoft

Le 4 nov. 2013 à 10:56, Katelyn Rogers a écrit :

> Hi Darren, 
> 
> I have cc'd the product mailing list and Philippe Plagnol (founder of Product Open Data).
> 
> I am very pleased to here that you are using the Open Product Database for your dissertation and project. I would love to here more about what you are doing, these are the applications we are hoping to enable with the database and so its great to see this happening. I will let Phillippe and others in the group respond to your API question (although the short answer is, no we don't have one and would like to develop one). 
> 
> The project is now on Github and you can join the mailing list if you have any further questions or would like to contribute to the project.    
> 
> Please share your results and if you'd like to write about your experience, I would be happy to post it on our blog! Again, I am very pleased to here that you are using the database! 
> 
> All the best,
> Katelyn 
> 
> 
> 
> Dear Friends: 
>   
> I am currently working on a dissertation for my Masters of Science Degree in Information Systems Management.  My dissertation is the development of a discussion framework about how Information Communications Technologies can be used to address income inequality. 
>   
> For part of my project I have developed an Android Application that scans in an EAN and returns to the user information about the manufacturer and retailer.  Specifically their net profits, the executive and their compensation, the number of employees and their average compensation.  As well as the multiple of the highest compensated Executive is versus what the average employee earns.  Users are then asked to take a survey constructed to measure if that information influenced their purchasing decision in the present, or likely to influence their preference in the future. 
>   
> The point of the application and survey is to assess to what degree consumers purchasing behaviour is influenced by their having knowledge - at, or near the time of purchase, of how their purchase is contributing to income inequality.  
>   
> I have taken the liberty of using the data from Product Open Data - thank you!  
>   
> However, I was wondering if you have, or are planning on developing an api? 
>   
> Additionally if you have any interest in the results, or advice to give, I would be willing to both provide and receive. 
>   
> Sincerely, 
> Darren Gudmundson
> 
> 
> -- 
> Katelyn Rogers
> Working Groups Community Manager  | katelyn.rogers at okfn.org  | Skype: katelynjrogers
> The Open Knowledge Foundation
> Empowering through Open Knowledge
> http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog  |  Newsletter
> _______________________________________________
> Product mailing list
> Product at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/product

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/product/attachments/20131108/21606f3b/attachment.html>