USER_TO_ITEM_RECOMMENDATION

Learns from previous transactions to predict which items are more likely to be of interest to or purchased by a customer. Returns in JSON format a list of predicted items according to the usage history of the user.

Syntax

USER_TO_ITEM_RECOMMENDATION( model_id, user_id, no_of_results, api_url, recommendations_api_key )

Arguments

model_id

Unique identifier of the model. It's a character expression.

user_id

Unique user identifier. It's a character expression.

no_of_results

A number of recommended items to return. A number expression which returns int value.

api_url

Azure recommendations API URL.

recommendations_api_key

A subscription key which is related to Azure subscription.

Return types

nvarchar(128)

Example

SELECT USER_TO_ITEM_RECOMMENDATION(
  'b47284dd-b2b0-4a51-a3a7-83b20b88d2bb',
  'https://westus.api.cognitive.microsoft.com/recommendations/v4.0',
  '474a8bf55bdb4c219830aee011061d60')