Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PLEASE HELP: Connecting to SOA/API for Dataset?

Hi all,

 

I'm really struggling here with connecting to (I think?) an SOA API.  I've done connections with Webcontents/Rest API's no problem in Power BI.  Never really worked with this other style though.  Not really sure where to begin.  Can someone provide a quick sample of how to connect?  Can it be done with webcontents?

 

The API document shows:

 

Sample Request:

 

<request>
<auth_token>API_TOKEN</auth_token>
<function_name>search_users</function_name>
<soa_version>1</soa_version>
<language>en</language>
<data>
<criteria field='user_lastname'>Hunt</criteria>
</data>
</request>

 

 

Sample Replies:

 

<response xml:lang="en">
<soa_message>
<users>
<user>
<user_id>1730</user_id>
<user_last_modified>2016-11-21 09:00:51</user_last_modified>
<user_date_created>2015-11-09 03:10:12</user_date_created>
<state_id>48</state_id>
<user_email>[email protected]</user_email>
<user_firstname>Owen</user_firstname>
...removed for clarity...
<position_code/>
</user>
<user>
<user_id>1997</user_id>
<user_last_modified>2016-11-21 09:00:51</user_last_modified>
<user_date_created>2016-06-15 03:10:13</user_date_created>
<state_id/>
<user_email>[email protected]</user_email>
<user_firstname>Caranthir</user_firstname>
...removed for clarity...
<position_code/>
</user>
</users>
</soa_message>
</response>

 

Sample Reply:

 

Need Help

1 Reply

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi Anonymous , 

    I am not familiar with SOA API, if possible, could you please provide the link of SOA API tutorial ? By the way, you also could refer to working-with-web-services-in-power-query  for details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.