Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results for buildrowsetfromxml tagged with marketing-cloud
Search options not deleted
user 5202
The Salesforce Marketing Cloud is the leading 1:1 digital marketing platform, connecting companies with customers in entirely new ways. Platform APIs and SDKs enable developers to manage and automate marketing campaigns and extend the Marketing Cloud with integrated apps and app extensions.
4
votes
Accepted
Using AMPscript to pull XML from DE
(@xml,concat(@nodepath,"sku"))) > 0 then
set @sku = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"sku"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath … ,"name"))) > 0 then
set @name = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"name"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath,"url"))) > 0 …
- 31.1k
3
votes
Accepted
ExactTarget won't let me define variable as subscriber's email address
cat_user_email=", @email,"&id=",@post_id)
/* don't need the v() function on this */
/* set @xml = HTTPGet(v(@url)) */
set @xml = HTTPGet(@url)
Set @titles = BuildRowsetFromXML(@xml,"//item/title",1 … )
Set @descs = BuildRowsetFromXML(@xml,"//item/description",1)
Set @pubdas = BuildRowsetFromXML(@xml,"//item/pubDate",1)
Set @links = BuildRowsetFromXML(@xml,"//item/link",1)
/* not sure what this is …
- 31.1k
2
votes
Accepted
Variable not defined on Data Extension but able to print it in content
(@xml,concat(@nodepath,"sku"))) > 0 then
set @sku = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"sku"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath … ,"name"))) > 0 then
set @name = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"name"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath,"url"))) > 0 …
- 31.1k
2
votes
Accepted
Nested FOR loop in AMPScript after reading from XML
For iterating through the child elements, you'll need to utilize the XPATH index to limit the scope of the BuildRowSetFromXML() results (as in the example I cited in my comment). … <experience>2 years</experience>
<talent-name>walking</talent-name>
<experience>3 years</experience>
</talents>
</parent-object>
</root>"
set @names = BuildRowsetFromXML …
- 31.1k
2
votes
How to add two values from a single field with AMPscript
.
%%[
var @xml, @isXML, @nodes, @rowCount
set @xml = AttributeValue("xml")
if indexOf(@xml,"<cart>") > 0 then
set @nodes = BuildRowsetFromXML(@xml,"/cart/items/item",0)
set @rowCount = rowcount … (@xml,concat(@nodepath,"sku"))) > 0 then
set @sku = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"sku"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath …
- 31.1k
2
votes
Accepted
How to create an AMPScript Array or dynamic var?
The best you can do for arrays in AMPScript is to use the buildrowset functions -- BuildRowSetFromString() and BuildRowSetFromXML(). …
- 31.1k
2
votes
Accepted
How to use Field(Row(BuildRowSetFromXML()) to only target a field with a specific “attribute...
You can reference node attributes like this using XPATH 1.0 syntax:
if rowcount(BuildRowsetFromXML(@XML, '/custom-attributes/custom-attribute[@attribute-id="neededField"]')) > 0 then
set @neededField … = Field(Row(BuildRowsetFromXML(@XML, '/custom-attributes/custom-attribute[@attribute-id="neededField"]',0),1), 'Value')
endif …
- 31.1k
2
votes
loading XML files in to a Data extension and using it as a look up table
You can have XML in a Data Extension column and then parse it with the BuildRowSetFromXML() function or transform it using the TransformXML() function and an XSLT file in the Portfolio. … I have a sample solution utilizing the BuildRowSetFromXML() here on my blog . …
- 31.1k
2
votes
Why does my AMPscript only loop once?
if rowcount(BuildRowsetFromXML(@order_xml,concat(@nodepath,"/CLASSIF_NAME"))) > 0 then
set @classif_name = Field(Row(BuildRowsetFromXML(@order_xml,concat(@nodepath,"/CLASSIF_NAME"),0) … if rowcount(BuildRowsetFromXML(@order_xml,concat(@nodepath2,"/STATUS_DISPLAY_ORDER"))) > 0 then
set @status_display_order = Field(Row(BuildRowsetFromXML(@order_xml,concat(@nodepath2,"/STATUS_DISPLAY_ORDER …
- 31.1k
2
votes
Three FOR loops in ampscript after reading from XML
.
%%[
set @itemNodes = BuildRowsetFromXML(@xml,"eReceiptPOS/receiptLine",0)
set @itemRowCount = rowcount(@itemNodes)
if @itemRowCount > 0 THEN
FOR @i = 1 to @itemRowCount DO
set @itemNodePath … = concat("/eReceiptPOS/receiptLine[",@i,"]/")
IF rowCount(BuildRowsetFromXML(@xml,concat(@itemNodePath,'/itemUPC'),0)) > 0 then
set @itemUPC = Field(Row(BuildRowsetFromXML(@xml,concat …
- 31.1k
2
votes
How to sort line items by OrderLineStatus in XML when AMPScript is looping?
Here's a simple example of the AMPScript side:
%%[
set @xml = AttributeValue("xml")
Set @xslt = GetPortfolioItem("OrderConfirmation")
Set @l = Length(@xslt)
set @regionRowSet = BuildRowSetFromXML …
- 31.1k
1
vote
Row Count error
(@xml,concat(@nodepath,"sku"))) > 0 then
set @sku = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"sku"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath … ,"name"))) > 0 then
set @name = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"name"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath,"url"))) > 0 …
- 31.1k
1
vote
Return null value, if node not present in RSS-feed (ampscript)
(@xml,concat(@nodepath,"sku"))) > 0 then
set @sku = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"sku"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath … ,"name"))) > 0 then
set @name = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"name"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath,"url"))) > 0 …
- 31.1k
1
vote
BuildRowsetFromXML question
) do
SET @xmlrows = row(@xml, @j)
SET @xmlls = field(@xmlrows, "CODE__HTML")
if indexOf(@xml,"<TourInfo>") > 0 then
set @nodes = BuildRowsetFromXML … if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath,"Name"))) > 0 then
set @TourName = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"Name"),0),1),'Value') …
- 31.1k
1
vote
AMPscript Error with XML
(@xml,concat(@nodepath,"sku"))) > 0 then
set @sku = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"sku"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath … ,"name"))) > 0 then
set @name = Field(Row(BuildRowsetFromXML(@xml,concat(@nodepath,"name"),0),1),'Value')
endif
if rowcount(BuildRowsetFromXML(@xml,concat(@nodepath,"url"))) > 0 …
- 31.1k