How to get data from API

[confis]

Hi ,

I am try to get the value from this XML (value1,value2) from URL

<ArrayOfstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays"><string>value1</string><string>value2</string></ArrayOfstring>

I have tried to use the below on filed with eval - yes

$xml = json_decode(file_get_contents('api_url'));
return $xml ;

also try this

$xml = SimpleXmlElement(file_get_contents('api_url'));
return ($xml->values);


But with no help ;(

do you have any advice how to make it work?

Thanks
Yaniv

 

[troester]

'api_url' is a string, no URL.
What are you trying to access?

 

[confis]

This is place holder for the url

Sent from my ONEPLUS A3010 using Tapatalk

 

[confis]

The answer from the URL is <ArrayOfstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays"><string>value1</string><string>value2</string></ArrayOfstring

Sent from my ONEPLUS A3010 using Tapatalk

 

[confis]

$xml = json_decode(file_get_contents('https://mydomin.com/api'));
return $xml ;

Sent from my ONEPLUS A3010 using Tapatalk

 

[troester]

Try to debug, something like
$x =file_get_contents(...);
var_dump($x);exit;

or use the extension J!Dump

 

[confis]

I try this

$x =file_get_contents(...);
var_dump($x);exit;

Not working

Wwhen i use this

$xml = xml_parser_create(file_get_contents($url));
return $xml;

i receptive
Resource id #218

any idea how to get the value from this xml?

<ArrayOfstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays"><string>value1</string><string>value2</string></ArrayOfstring>

Thank you!

 

[troester]

Try with SimpleXMLElement
https://www.w3schools.com/php/php_xml_simplexml_read.asp

 

[cheesegrits]

If that var_dump() isn't showing anything, then that file_get_contents() probably isn't returning anything.

It would help if you could give us the URL you are pulling data from.

-- hugh

 

[confis]

Thanks, this is the url
https://shamirpapi.com:444/PAPI/values

Sent from my ONEPLUS A3010 using Tapatalk

 

[cheesegrits]

This works for me ...

$content = file_get_contents('https://shamirpapi.com:444/PAPI/values');
$json = json_decode($content);

$json is then an array. not sure what you want to do with it. If you wanted to return it as a comma separated string ...

return implode(',', $json);

You could probably simplexml_load_string($content) if you wanted to do xml-ish stuff with it.

-- hugh

 

[confis]

Thank you

I have tried this but I'm getting nothing

$content = file_get_contents('https://shamirpapi.com:444/PAPI/values');
$json = json_decode($content);
return implode(',', $json);

http://order.shamir-optical.com/rest/details/1/?fromForm=1

 

[troester]

It's working fine here.
Where do you use this code, what are you trying to achieve?

 

[confis]

On field element

Sent from my ONEPLUS A3010 using Tapatalk

 

[troester]

Can you be a bit more specific?

And what should your link to a details view show?

 

[confis]

This is the link to the xml
https://shamirpapi.com:444/PAPI/values');

I used $content = file_get_contents('https://shamirpapi.com:444/PAPI/values');
$json = json_decode($content);
return implode(',', $json);

But I'm getting no values
You can see empty values on my page
http://order.shamir-optical.com/rest/details/1/?fromForm=1

At REST_TEST

Sent from my ONEPLUS A3010 using Tapatalk

 

[troester]

A details view of a non-existing record is always empty.
And you still didn't mention where you are using this code (calc element, element default, custom template, validiation condition,... there are many places)

 

[confis]

Hi,

A details view of a non-existing record is always empty.

from this url i am getting this values
https://shamirpapi.com:444/PAPI/values

<ArrayOfstring><string>value1</string><string>value2</string></ArrayOfstring>

I am using the Field element

 

[troester]

A default is evaluated only in the form when you are adding a new record.

A details view is showing what is stored in the database after you have added (and saved) the record.

So if you are showing the details view of an non-existing record (as with your link) you'll see nothing

 

[confis]

I referred to this post

http://fabrikar.com/forums/index.php?threads/store-data-from-restful-api.34316/

To get the value