API integration

cbrei · June 4, 2015

I'm attempting to set up menus (and other info) from the SinglePlatform service: https://www.singleplatform.com/ to a WordPress site

They have some resources:

I'm running into trouble with structuring the data retuned from the API into a PHP array, where I can then use to populate the site with individual menu items, etc.

I have this php code:

<?php
$client_key = 'c3sbrpbtkbs5gverurfkxpemc';
$sig_key = 'PkkJXNRpO2l0r5u6u0PlCNme1KA8akGejMIjHI5Gkj8';
$base_url = '/locations/horse-inn/menus/?client=' . $client_key;
$url = hash_hmac('sha1',$base_url, $sig_key, true);
$str = urlencode(base64_encode($url));
$fnl_url = 'http://publishing-api.singleplatform.com'.$base_url.'&signature='.$str;
$ch = curl_init($fnl_url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec( $ch );
$result = json_decode($response, true);

parse_str($response, $valueArray);
echo "<pre>", print_r($valueArray, true), "</pre>";
?>

where $client_key and $sig_key are unique variables for my SinglePlatform account

the return looks like this:

I have never done an API integration into PHP and am somewhat knowledgable of PHP, but obviously not enough to figure out how to manipulate the API data

the menu looks like this on the SinglePlatform site: http://w.singlepage.com/horse-inn/menu

many thanks in advance for assistance in resolving this issue

dalecosp · June 4, 2015

Look quite a bit like JSON?

Have you tried json_decode() on this?

Edited June 4, 2015 by dalecosp

cbrei · June 5, 2015

Correct, it is JSON - and that's part of my issue (I think) - I have a line of code in there:

$result = json_decode($response, true);

but I'm not sure if I'm using it properly, or if the JSON is structured properly to begin with

thanks

QuickOldCar · June 5, 2015

More like this and now can access any array or loop through them.

<?php
$client_key = 'c3sbrpbtkbs5gverurfkxpemc';
$sig_key = 'PkkJXNRpO2l0r5u6u0PlCNme1KA8akGejMIjHI5Gkj8';
$base_url = '/locations/horse-inn/menus/?client=' . $client_key;
$url = hash_hmac('sha1',$base_url, $sig_key, true);
$str = urlencode(base64_encode($url));
$fnl_url = 'http://publishing-api.singleplatform.com'.$base_url.'&signature='.$str;
$ch = curl_init($fnl_url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec( $ch );
$result = json_decode($response, true);

//echo "<pre>", print_r($result), "</pre>";

if($result['data']){
	foreach($result['data'] as $data){
		echo "<pre>", print_r($data), "</pre>";
	}
	
}
?>

QuickOldCar · June 5, 2015

I'll help a bit more in case not familiar with what to do the rest.

You can assign variables, style as want, however you would like to use the data.

<?php
$client_key = 'c3sbrpbtkbs5gverurfkxpemc';
$sig_key    = 'PkkJXNRpO2l0r5u6u0PlCNme1KA8akGejMIjHI5Gkj8';
$base_url   = '/locations/horse-inn/menus/?client=' . $client_key;
$url        = hash_hmac('sha1', $base_url, $sig_key, true);
$str        = urlencode(base64_encode($url));
$fnl_url    = 'http://publishing-api.singleplatform.com' . $base_url . '&signature=' . $str;
$ch         = curl_init($fnl_url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($ch);
$result   = json_decode($response, true);

//echo "<pre>", print_r($result), "</pre>";

if ($result['data'] && $result['code'] == "200") {
    foreach ($result['data'] as $data) {
        
        //echo "<pre>", print_r($data), "</pre>";
        
        echo $data['id'] . "<br />";
        echo $data['location_id'] . "<br />";
        echo $data['name'] . "<br />";
        echo $data['description'] . "<br />";
        echo $data['menu_type'] . "<br />";
        echo $data['footnote'] . "<br />";
        echo $data['order_num'] . "<br />";
        echo $data['currency'] . "<br />";
        echo $data['created'] . "<br />";
        echo $data['updated'] . "<br />";
        echo $data['attribution_image'] . "<br />";
        echo $data['attribution_image_link'] . "<br />";
        
        foreach ($data['sections'] as $sections) {
            echo $sections['order_num'] . "<br />";
            
            foreach ($sections['items'] as $items) {
                echo $items['name'] . "<br />";
                echo $items['description'] . "<br />";
                
                //got lazy, you can keep going
                echo "<pre>", print_r($items['choices']), "</pre>";
                
                
                
            }
            
        }
   
    }
    
}
?>

cbrei · June 5, 2015

wow - this was SUPER helpful!

I am nearly there I think - I just can't get the price to display, here is what I have:

<?php
$client_key = 'c3sbrpbtkbs5gverurfkxpemc';
$sig_key    = 'PkkJXNRpO2l0r5u6u0PlCNme1KA8akGejMIjHI5Gkj8';
$base_url   = '/locations/horse-inn/menus/?client=' . $client_key;
$url        = hash_hmac('sha1', $base_url, $sig_key, true);
$str        = urlencode(base64_encode($url));
$fnl_url    = 'http://publishing-api.singleplatform.com' . $base_url . '&signature=' . $str;
$ch         = curl_init($fnl_url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($ch);
$result   = json_decode($response, true);

if ($result['data'] && $result['code'] == "200") {
    foreach ($result['data'] as $data) {

        if ($data['id'] == "1542722") {
        
        foreach ($data['sections'] as $sections) {
    
            foreach ($sections['items'] as $items) {
                echo "<ul id='menu_item'>";
                echo "<li id='title'>" . $items['name'] . "</li>";
                echo "<ul id='ingredients'><li>" . $items['description'] . "</li></ul>";
                
                    foreach ($items['choices'] as $choices) {

                        foreach ($choices['prices'] as $prices) {
                            echo "<li id='price'>" . $prices['min'] . "</li>";
                        }

                    }
                
                echo "</ul>";
                
                
            }
            
        }
            
        }
   
    }
    
}
?>

thoughts?

QuickOldCar · June 5, 2015



foreach ($items['choices'] as $choices) {

     echo "<li id='price'>" . $choices['prices']['min'] . "</li>";

}

cbrei · June 7, 2015

ah - wicked good! thanks for the guidance!

Sign In

API integration

Recommended Posts

cbrei

Link to comment

Share on other sites

dalecosp

Link to comment

Share on other sites

cbrei

Link to comment

Share on other sites

QuickOldCar

Link to comment

Share on other sites

QuickOldCar

Link to comment

Share on other sites

cbrei

Link to comment

Share on other sites

QuickOldCar

Link to comment

Share on other sites

cbrei

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information