Get a bunch of data from facebook and dump it to a powershell file

Download-Infos.ps1

$tokens = cat .\facebook-tokens.csv
pushd

$wc = New-Object Net.WebClient
mkdir infos
cd infos

$cntr = 0
foreach($t in $tokens) {
    $cntr += 1
    Write-Host "Downloading $cntr of $($tokens.Length) - $t"
    $url = "https://graph.facebook.com/me?access_token=$t"
    $wc.DownloadString($url) | Out-File "$t.json"
}

popd

Transform-ToCsv.ps1

 $jsonFiles = ls .\infos  #| select -first 10
 $tokens = $jsonFiles | select -ExpandProperty Name | %{ ($_ -replace "json", "")}
 $jsons =  $jsonFiles | select | cat | ConvertFrom-Json 
 $cnt = 0
 $convertedObj = foreach($obj in $jsons) {
    $hash = @{}
    foreach($prop in $obj.psobject.properties) {
        if($prop.TypeNameOfValue -eq 'System.String') {
            $hash[$prop.Name] = $prop.Value
        } else {
            $hash[$prop.Name] = ($prop.Value | ConvertTo-Json -Compress)
        }
    }
    if($obj.location) {
        $hash.location_name = $obj.location.Name
        $hash.location_id = $obj.location.Id
    }
    $hash.token = $tokens[$cnt]
    $cnt += 1
    new-object psobject -Property $hash
}
$convertedObj | Export-Csv ./infos.csv

edit ./infos.csv