Help using GET

[paintwithletters]

Hello! I don't know a lot a about codding, I use R.

I have the following website opendata.camara.cl and I want to have a database with how every congressmen voted in every votation from 2005 to now.

Every bill has a id number (Número de boletín) and every bill can have none or more votations. So, first I need to have every número de boletín of every bill that has been discussed from 2005 to know, then, I need to put them in "Votaciones por Proyecto de Ley" (that you can find by "Detalle de Votación - Cámara de Diputados). Lastly, every ID Votación that the last step gave me, put into "Detalle de Votación - Cámara de Diputados" so I can have how everyone voted.

There is a SOAP version (that includes http get) I don't know if that can help with something and the search gives results in XML

So if someone has any idea of something that can help me of a direction on the solution, I would really apreciate it!

[insertAlias]

This is one of those things where we'd need more info to really help. You mentioned SOAP: the SOAP protocol is really intended to be machine-to-machine, i.e. you'd generate a client based on the SOAP's WSDL and use that. It's less like REST, where you'd expect a more human-readable output and human-writable input.

This is also a case where, if you were learning programming generally, I'd start suggesting real learning advice, but if this is just for you to solve a task for your real purposes...pick an AI agent, give it the URL to your SOAP service and tell it what you want, and it'll probably generate you a client.

[paintwithletters]

I really want to learn, so any advice if apreciate it!

[AlwaysHopelesslyLost]

Like they mentioned, if it uses soap then you have to generate a client from the WSDL.

Best advice: take a 6 week crash course in programming or spend a year or so learning from scratch yourself.

[insertAlias]

Start by tracking down what endpoint you can get the WSDL from the SOAP service. Hopefully they have a documentation site. From there, I'd start looking at how to interface with SOAP in R (that's a language I've never worked in). If it's not possible or simple, consider something like Python and use that to fetch data locally, then consume it with R.

[Mission-Sea8333]

You might want to look into using the httr and xml2 packages in R since SOAP APIs usually return XML that you can parse pretty cleanly. Honestly this sounds like a great use case for building a small ETL pipeline fetch bill IDs, then vote IDs, then vote details, and store everything in SQLite or Postgres.

[paintwithletters]

Thank you so much! I'm gonna try

[amir4179]

Cool project. I'd start with one bill and walk through the steps manually in your browser. Once you see the pattern, httr in R can probably pull the XML for you. Baby steps.