For my sanity I did a quick test as I do it a lot with no issue, the problem with your script is what I said a little earlier up.
Original Message:
Sent: 07-30-2026 03:46
From: Simon Redmile
Subject: Datalinq through Scripting
The other method definitely works as well I use it a lot.
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------
Original Message:
Sent: 07-28-2026 13:45
From: Ben Kessler
Subject: Datalinq through Scripting
just got it working with a script I found on the forum a few years ago (just need to make sure the text objects are published):
for i as integer = 1 to 50
dim takeitem as xpTakeItem
dim template as xpPublishedObject
dim dl as xpDatalinq
engine.Sequencer.GetFocusedTakeItem(takeitem)
takeitem.GetPublishedObjectByName("INJURY FULL NAME" & i, template) 'whatever your text object name is
template.GetDatalinq(0, dl)
dl.LinkName = "NBA Injury Report - All Teams" 'whatever your datalinq name is
dl.Column = "players<" & i & ">" 'whatever your column path is
dl.Row = "playerName" 'whatever your row path is
dl.Table = "" 'whatever your table name is
template.SetPropertySourceType(0, 1)
next
------------------------------
Ben Kessler
Orlando United States
------------------------------
Original Message:
Sent: 07-28-2026 13:19
From: Ben Kessler
Subject: Datalinq through Scripting
I've managed to get it working with some datalinq's that are excel sheets using your script, but I'm still having trouble making it work with datalinq's from JSON based API's, where the row is a string value and not a number. Is it possible for the row to be a string in scripting, could this be what is stopping it from loading?
------------------------------
Ben Kessler
Orlando United States
------------------------------
Original Message:
Sent: 07-28-2026 12:33
From: Simon Redmile
Subject: Datalinq through Scripting
Now you can index anything, I just don't think your script is quite right if you look at mine.
textObj.DataLinq.Column
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------
Original Message:
Sent: 07-28-2026 12:27
From: Ben Kessler
Subject: Datalinq through Scripting
Does this mean that the row is the index, or that the row is the only section that is able to be moved on to the next index through scripting? I'll try a few different methods to see if I can get it working on my end
------------------------------
Ben Kessler
Orlando United States
------------------------------
Original Message:
Sent: 07-28-2026 11:52
From: Simon Redmile
Subject: Datalinq through Scripting
I think the format for datalinq is more like this;
textObj.DataLinq.LinkName = "PlayerData"
textObj.DataLinq.Column = "FirstName"
textObj.DataLinq.Row = 5
textObj.DataLinq.Table = "Roster"
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------
Original Message:
Sent: 07-28-2026 10:37
From: Ben Kessler
Subject: Datalinq through Scripting
Hey Simon,
It seems to be defaulting to the first index with that script, I tried hardcoding in "players<2>" in the script but appear to be getting the same result.
I'm not sure if where I place the script matters, I've tried moving it around to online, preview render, and onset text but no luck so far
Do you know if it might have anything to do with the column datalinq property?
------------------------------
Ben Kessler
Orlando United States
------------------------------
Original Message:
Sent: 07-28-2026 05:18
From: Simon Redmile
Subject: Datalinq through Scripting
yes this line here looks correct to me
textObj.Column = "players<" & i & ">"
it is not working for you?
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------