jj20051 Posted January 25, 2009 Share Posted January 25, 2009 I have an API full of phone calls made to my 1-800 number last year. What I would like to do is strip off all of the calls that: were duplicates, were calls made by one of my 3 phones to test, lasted less than 15 seconds or calls made out side 1 of 4 area codes. I realize no one person has the awnswer to all of this. So I would love some pointers and advice. ( If you want to write something to help me, that would be awsome! ) The API URL: http://www.tollfreeforwarding.com/api/?u=schuldr&p=kingdom&format=html&rangeStart=20080101&rangeEnd=20081231&timezone=-6 Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/ Share on other sites More sharing options...
Prismatic Posted January 25, 2009 Share Posted January 25, 2009 Can you list out the column names so we know what we're looking at? Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745651 Share on other sites More sharing options...
jj20051 Posted January 25, 2009 Author Share Posted January 25, 2009 ID,Number Dialed,Calling From,Forwarded To,Start Call,End Call,Duration,Code Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745686 Share on other sites More sharing options...
redarrow Posted January 25, 2009 Share Posted January 25, 2009 no print the core database so we no what there for or tell us give a database example... Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745690 Share on other sites More sharing options...
jj20051 Posted January 25, 2009 Author Share Posted January 25, 2009 Two Words: I'm lost! Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745694 Share on other sites More sharing options...
redarrow Posted January 25, 2009 Share Posted January 25, 2009 example like this mate <<<<< means database format example. ID <<<<<< Number <<<<<<< Dialed <<<<<<< Calling From <<<<<< Forwarded To <<<<< Start Call <<<<< End Call <<<<< Duration <<<<< Code <<<<< Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745727 Share on other sites More sharing options...
rubing Posted January 25, 2009 Share Posted January 25, 2009 If you want me to write it, you should post this in the freelance section and let me know how much moola you will pay me. Now if you want help writing it we will give that to you free. Why don't you just ask us how to do a single thing? or try doing something yourself and tell us how it failed. Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745731 Share on other sites More sharing options...
trq Posted January 25, 2009 Share Posted January 25, 2009 example like this mate <<<<< means database format example. ID <<<<<< Number <<<<<<< Dialed <<<<<<< Calling From <<<<<< Forwarded To <<<<< Start Call <<<<< End Call <<<<< Duration <<<<< Code <<<<< There is no database involved redarror. Read the post. Personally I wouldn't use php for this. Sounds more like a job for bash, grep and awk. I can point you to a few awk tutorials but other than that, I don't have much. Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745733 Share on other sites More sharing options...
jj20051 Posted January 25, 2009 Author Share Posted January 25, 2009 That's not exactly what I wanted to hear. I thought almost anything is possible with php Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745749 Share on other sites More sharing options...
corbin Posted January 25, 2009 Share Posted January 25, 2009 Just because something is possible one way does not mean that said way is the best way ;p. Anyway, don't take this the wrong way, but uhh... do you know any PHP at all? This isn't very hard unless there's something I'm missing. Do you have a specific question, or do you not know where to start? Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745751 Share on other sites More sharing options...
jj20051 Posted January 25, 2009 Author Share Posted January 25, 2009 I don't know where to start is the main problem. If i could get the data to seperate into "virtual tables" I would be fine from there. Even a script to convert it from the api into a database would make my life easier by 5x Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745754 Share on other sites More sharing options...
corbin Posted January 25, 2009 Share Posted January 25, 2009 http://php.net/explode would be the first step of separating the data. Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-745757 Share on other sites More sharing options...
trq Posted January 25, 2009 Share Posted January 25, 2009 That's not exactly what I wanted to hear. I thought almost anything is possible with php I didn't say it wasn't possible with php. Its just IMO there are better tools for this job. Link to comment https://forums.phpfreaks.com/topic/142309-solved-using-php-with-an-api-to-get-specific-results/#findComment-746100 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.